how to find nth highest salary
- 103 Answers
- 163910 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / sharmila shree
SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary
here 'a' is sub query of salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is catalog views?
Explain full-text query in sql server?
What is shared lock?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How can we migrate from SQL server to SQL Azure?
What does indexation mean?
What are entities and relationships?
What is server-level principal?
Find nth lowest salary or get nth lowest salary?
When multiple after triggers are attached to sql table, how to control the order of execution?
How to check if stored procedure is running in sql server?
Explain filestream storage of sql server 2008?
What is transaction server explicit transaction?
What is measure group, measure? : sql server analysis services, ssas
