AVG – Return avarage number – SQL Aggregate Functions
AVG function returns average number from a specific column.
example: to find average value of employees’ salary.
SELECT AVG(salary) FROM tbSalaryTable; AVG(salary) ----------------------------------------- 254000
Posted in Aggregate Functions
Categories
PR
Recent Posts
- CHARINDEX – Return a starting position in a specific character – Character Functions
- ChAR, CHR – Convert ASCII code to character – Character Functions
- ASCII – Convert character to ASCII code – Character Functions
- SUM – Return summation of selected column – Aggregate Functions
- STDDEV, STDEV – Return standard deviation of selected column – Aggregate Functions
- MIN – Return minimum value of selected column – Aggregate Functions
- MAX – Return largest value of selected column – Aggregate Functions
- COUNT – Count the number of records – Aggregate Functions
- AVG – Return avarage number – SQL Aggregate Functions