how to find nth highest salary
Answer Posted / kunal gupta
select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal
This answer is easiest and 100% tested
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the differences between web role and worker role?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is explicit mode in sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Define self join in sql server joins?
What are the options which must be set to allow the usage of optimistic models?
Mention a few common trace flags used with sql server?
What command would you use to add a column to a table in sql server?
Tell me something about security and sql azure?
What do you understand by recursive stored procedure?
How do I start and stop sql server?
why would you call update statistics? : Sql server database administration
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Explain what is dbcc?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?