SQL stateent to find 5th Highest salary

[muralirajan]

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


muralirajan

[Lothar Haensler]

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.