SAS
Sunday, 9 October 2011
SQL- Aggregate Functions- AVG()
n
The 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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment