how to find nth highest salary
- 103 Answers
- 163904 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / satesh naidu
select * from emp e1 where &n=(select count(distinct
(e2.sal) from emp e2 where e.sal>e1.sal)
Hai friends try this.u will get nth highest salary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is read committed?
Explain the purpose of indexes?
How can I check if a view exists in a sql server database?
How to add a new dsn with the odbc driver for sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Mention a few common trace flags used with sql server?
What are the steps to follow to configure SQL*Net?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain what is row_number function?
Difference between Inner vs outer joins?
how would you store your query in an SSRS report or a Database server?
What do you understand by intent locks?
What are the reporting services components?
what is a self join? Explain it with an example? : Sql server database administration
What does ss stand for sexually?
