Aggregate functions
  • AVG, SUM, COUNT, MAX, MIN  are aggregate functions in SQL.
  • They can be applied to any column of a table.
  • They can be used in select clause of SQL queries.
  • They always discard NULL values, only coun(*) takes into consideration NULL values.

Contributor's Info

Created:
0Comment