Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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.

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:

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:

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)

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.