Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 179692 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
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Is it possible to call a stored procedure within a stored procedure?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to receive returning result from a query?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is microsoft sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the difference between commit and rollback?
what are the different ways to return the rowcount of a table?
How do you set a trace flag in sql server?
What is an execution plan?
What is format parameter in ssrs?
What is the maximum row of a size?
explain different types of cursors? : Sql server database administration
What is field in algebra?
