clock  Mon - Sun 8.00 AM - 8.00 PM
mail  edu@teknowize.com
fb
instagram
play store
pinterest

More

SQL aggregate function

Imperial Advance Hero Image

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

MySql