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 is table level trigger?
What is your recommendation for a query running very slow? : sql server database administration
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
how can you attach more than 20 ldf files in sql server
What is default constraint?
How to select true false based on column value in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Which Model uses the SET concept
What are the main sources of data?
What are the properties of the transaction?
How to define the name and server for a new dsn?
Can another user execute your local temporary stored procedures?
What are different backups available in sql server?
Describe in brief sql server monitoring ways.