I need help with queries and functions in LibreOffice Base

[mrmister]

Hello
I’m starting with queries and functions. Right now I know how to tackle queries, but I don’t know very well how may I use functions on queries. I would like to master all functions, so I need examples with functions. The problem is I don’t know where may I find help with this?
I’d like to see samples about these functions:

Average, Count, Maximum, Minimum, Sum, Every, Any, Some, STDDEV_POP, STDDEV_SAMP, VAR_SAMP, VAR_POP, Collect, Fusion, Intersection, Group

Sadly I don’t have seen any documentation from LibreOffice explaining every function with a sample.
Please, could someone give me some examples for these functions?
I’d like to see them working and what everyone do.
Cheers

[doug]

Base uses HSQLDB 1.8 by default, so refer to documentation for that application and version. Here is one that came up in my search. Basically, you will create a column in a SQL query with the function, i.e., REPLACE( "field1", 'hello', 'world' ) where the internal “” could also be backquotes (``). Add an alias and execute, save the query, and invoke the query with the function as a recordsource.

[mrmister]

Hi there,
Well more than HSQLDB 1.8 documentation, what I was looking for are some .odb files with queries, showing some examples about these functions, so I could play with the queries and see how every function works.
Could you give me please, some .odb files, with some queries, so I could see how these functions work?
Cheers

[doug]

This forum does not have a native function for trading .odb files. The list of functions in the question is the same as the drop-down list in the query builder window. To see how it works, just add a field above the selected function, and in a second column choose the function Group with another field. Thus, the query SELECT "Field1", COUNT( "Field1" ) FROM "Table1" GROUP BY "Field1" will count the number of instances of each value in Field1, with maybe special treatment of nulls.