SQL stateent to find 5th Highest salary

Please send me the SQL Statement to find the Employee row who is getting the 5th highest salary?


muralirajan

if you database supports the "SELECT TOP n"-Syntax (e.g. SQLServer 7) you can try "SELECT TOP 5 * FROM ... ".
Since the return value can be more then 1 employee, you'd have to read all values.