SQL – Count(), Avg() and Sum() Function
Table Of Contents:
- What Is Count(), Avg() and Sum() Function?
- Syntax Of Count(), Avg() and Sum() Function.
- Examples Of Count(), Avg() and Sum() Function.
(1) What Is Count(), Avg() and Sum() Function?
- The
COUNT()function returns the number of rows that matches a specified criterion. - The
AVG()function returns the average value of a numeric column. - The
SUM()function returns the total sum of a numeric column.
(2) Syntax Of Count(), Avg() and Sum() Function?
Syntax: Count()
SELECT COUNT(column_name)
FROM table_name
WHERE condition;Syntax: Avg()
SELECT AVG(column_name)
FROM table_name
WHERE condition;Syntax: Sum()
SELECT SUM(column_name)
FROM table_name
WHERE condition;(3) Exampls Of Count(), Avg() and Sum() Function?
Demo Data:
Example-1:Count()
SELECT COUNT(ProductName)
FROM Products;
Example-2:Avg()
SELECT AVG(Price)
FROM Products;
Example-3:Sum()
SELECT SUM(Price)
FROM Products;
