You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Aggregate functions return a single value, calculated from values in a column.

  • AVG() - Returns average value
  • COUNT() - Returns number of rows
  • MAX() - Returns largest value
  • MIN() - Returns smallest value
  • SUM() - Returns sum
  • FIRST() - Returns value of the given expression evaluated for the first row of the query's result set
  • LAST() - Returns value of the given expression evaluated for the last row of the query's result set
  • No labels