Function
|
Description
|
Example
|
AVG
|
Returns the average value of a numeric column / expression
|
SELECT AVG(commission_rate) FROM sales_rep_tbl
|
COUNT
|
Returns the number of rows (without a NULL value) of a column / expression
|
SELECT COUNT(FirstName) FROM employee
|
COUNT(*)
|
Returns the number of selected rows
|
SELECT COUNT(*) FROM employee
|
MAX
|
Returns the highest value of a numeric or character column / expression
|
SELECT MAX(commission_rate) FROM sales_rep_tbl
|
MIN
|
Returns the lowest value of a numeric or character column
|
SELECT MIN(FirstName) FROM employee
|
SUM
|
Returns the total sum of a column
|
SELECT SUM(ytd_sales) FROM sales_rep_tbl
|
