Sunday, 9 October 2011

SAS SQL- Aggregate Functions- MAX()

nThe MAX() function returns the largest value of the selected column.
Syntax:
SELECT MAX(column_name) FROM table_name
Query:
SELECT MAX(Salary) AS Employee salary FROM EMPtbl1

No comments:

Post a Comment