Arrow
Logo

MySql

Introduction to SQL

SQL Database

SQL Table

SQL Warnings

SQL Keys

SQL where clause

SQL between operator

SQL logical operators

SQL like operator

SQL refining operator

SQL aggregate function

SQL CRUD Operations

SQL Functions

SQL Date Time Data Type

SQL Joins

SQL aggregate function

AuthorHariom Prajapati

Pubish Date03 Jul 2022

categoryMySql

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