Am 18.03.2015 um 16:00 schrieb xavier2: > 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 > > >
The availlable functions depend on the type database you are connected to. The bare minimum of functions in the file based databsaes (spreadsheet, text, dBase) is documented here: > http://www.openoffice.org/dba/specifications/file_based_functions.html File based databases support only one aggregation COUNT(*) The built-in HSQL 1.8 (which should better not be used embedded into the Base document) is documented here: > http://www.hsqldb.org/doc/1.8/guide/ch09.html Any resource on SQL can teach you how to use all these functions properly, particularly the aggregation funcions together with GROUP. [Tutorial] Calculations in databases (quick primer) > https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=26328 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted