• ⌂ Aggregate
• Functions
  • AVG()
  • COUNT()
  • GROUP_CONCAT()
  • MAX()
  • MIN()
  • SUM()

Aggregate Query Functions

cQL

Aggregate query functions are only available in cQL SELECT, WHERE and ORDER BY clauses when a GROUP BY is specified or implied.

• AVG() - Average fields/values from aggregated rows.
• COUNT() - Count the number of times the field is not NULL in aggregated rows.
• GROUP_CONCAT() - Concatenate grouped values into a comma-separated string.
• MAX() - Get the maximum value for field in aggregated rows.
• MIN() - Get the minimum value for field in aggregated rows.
• SUM() - Add multiple fields/values from aggregated rows.

• < Functions
• AVG() >