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
What is intellisense?
what is raid? : Sql server database administration
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Can coalesce return null?
What is bcnf normalization form?
What were the latest updates to SQL Azure service?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Define left outer join in sql server joins?
What is store procedure?
What is query parameter in ssrs?
How to achieve Paging of records in SQL SERVER?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Can I delete event logs?
What is a trigger and types of a trigger?
How to convert numeric expression data types by assignment operations?