Sunday, 9 October 2011

SQL- Aggregate Functions- AVG()

nThe AVG() function returns the average value of a numeric column.
Syntax:
SELECT AVG(column_name) FROM table_name
Query:
SELECT AVG(salary) AS Employee salary FROM EMPtbl1

No comments:

Post a Comment