LibreOffice BASE - I need help for functions in query design view

[mrmister]

Hello, I would need help, exactly, clear documentation with examples, about how may I use functions in the query design view in LibreOffice BASE (not interested about how to use functions in SQL at the moment).

The functions you can see in the menu (at the grid) in the query design view are:

Average

Count

Maximum

Minimum

Sum

Every

Any

Some

STDDEV_POP

STDDEV_SAMP

VAR_SAMP

VAR_POP

Collect

Fusion

Intersection

Group

I need some PDF or clear documentation, explaining how to use every function with a documented example.
Any idea where I can get that information?

Cheers

[EasyTrieve]

Just to give you a simple example, say you have a table of Cities and States and you want to know how many Cities are in each state. You can say SELECT State, Count(Cities) GROUP BY State. The result will be one record for each state, no matter how many records for that state, with the state name, and the count of cities in that state.

[mrmister]

No one is willing to help ?

[rautamiekka]

Jesus f Christ, with all that rep you should know this way of yours is wrong ! Don’t make answers that aren’t answers !

[mrmister]

Jesus and Christ are words I understand, what I don’t understand is the F. Explain me please, what mean the F.
I am asking for documentation showing me examples about functions, how to use functions. I need help with this.

[rautamiekka]

Delete this answer of yours.