how to find nth highest salary

Answer Posted / amit

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

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is intellisense?

691


what is raid? : Sql server database administration

632


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

666


Can coalesce return null?

644


What is bcnf normalization form?

755






What were the latest updates to SQL Azure service?

102


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

633


Define left outer join in sql server joins?

640


What is store procedure?

752


What is query parameter in ssrs?

122


How to achieve Paging of records in SQL SERVER?

668


Is it possible for a stored procedure to call itself or recursive stored procedure?

597


Can I delete event logs?

618


What is a trigger and types of a trigger?

645


How to convert numeric expression data types by assignment operations?

623