Thursday, January 10, 2008

nth Highest Record using SQL

The following query gives 3rd highest records from SQL.

SELECT TOP(1) salary FROM ( SELECT TOP(3) salary FROM Emp ORDER BY salary DESC)

Keywords: getting nth highest record, nth highest record, TOP

No comments: