SQL Aggregate Function


COUNT( ), MAX ( ), MIN ( ), AVG ( ) and SUM ( )

  • The COUNT ( ) function returns the number of rows that matches specified criteria.
  • The  MIN ( ) function used to specify the minimum value in the numeric column.
  • The  MAX ( ) function use to specified the maximum value in the numeric column.
  • The AVG ( ) function return the average value of a numeric column.
  • The SUM ( ) function returns the total sum of a numeric column.


Syntax -

select count () | max() | min() | avg() | sum()

from table_name ;

sql aggregate function