Skip to content

Latest commit

 

History

History
35 lines (28 loc) · 697 Bytes

Aggregators.md

File metadata and controls

35 lines (28 loc) · 697 Bytes
Raw

Aggregators supported by AlaSQL

SQL Standard

  • SUM()
  • AVG()
  • COUNT()
  • MAX()
  • MIN()
  • FIRST()
  • LAST()

Examples:

    SELECT COUNT()
    SELECT COUNT(one)
    SELECT COUNT(*)

Non-standard

  • AGGR() – operations on aggregated values
  • ARRAY() – create array of values
  • QUART() - 1st quartile
  • QUART2() - 2nd quartile
  • QUART3() - 3rd quartile
  • User-defined aggregators

Quartile aggregations are based on the European calculation.

Example of AGGR() aggregator (here avg1 = avg2)

    SELECT SUM(a) AS sm,� COUNT(*) AS cnt,� \
           AGGR(sm/cnt) AS avg1,� AVG(a) AS avg2� FROM data