Select salary from employees order by salary desc limit n-1,1;

how to find nth highest salary

Question Posted / amit

Answer Posted / amit

Select salary
from employees
order by salary desc
limit n-1,1;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How self join is different from outer join?

1063

How to find tables without indexes?

1032

How to link tables in sql server?

894

what stored procedure can you use to display the current processes? : Sql server administration

962

How secure is sql server database?

958

What is the difference between stored procedure and user defined functions?

1132

What is shared lock?

835

What is the difference between varchar and nvarchar datatypes?

1037

How do I find query history in sql server?

879

What are SSL and TSL protocols?

935

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

970

Can sql servers link to other servers like oracle?

795

What is update locks?

835

Explain what is it unwise to create wide clustered index keys?

932

What are security principals used in sql server 2005?

908