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
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is sql profiler. What are the default templates with it? : sql server database administration
Write a code to select distinct records without using the DISTINCT keyword.
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is a trigger? Why we need it?
How to drop an existing schema in ms sql server?
How to execute a sql statement using mssql_query()?
How to use column default values in insert statements in ms sql server?
What are commonly used odbc functions in php?
What stored by the tempdb ? : sql server database administration
What stored procedure would you use to view lock information?
How to check parameter value in stored procedure sql server?
What is a join in sql?
What are the methods used to protect against sql injection attack?
What is logshipping and its purpose?