-
SQL – Count(), Avg() and Sum() Function
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;
