Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 178811 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / dilip
SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain various data region available in ssrs with their use?
How to sort query output in descending order in ms sql server?
What is SubQuery in SQL Server 2008
What are sql server functions?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What do you mean by data integrity?
Define outer join in sql server joins?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is deploy, process and build? : sql server analysis services, ssas
How to provide login information for a new odbc dsn?
What is save transaction and save point?
How to view the error log for any specific instance? : sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
Difference between Sql server reporting services and Crystal reports?
What is the cpu pressure?
