How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 51582 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / ashish kumar
To find nth maximum salry
Select salary from tbl_name a where
n-1=(Select count(distinct(count(*))) from tbl_name b
where b.salary>a.salary)
| Is This Answer Correct ? | 10 Yes | 20 No |
Post New Answer View All Answers
What are trace flags and mention a few common trace flags used with sql server?
What is a deadlock and what is a live lock?
What is SQL Azure?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
We need to perform what steps in the following order to work with a cursor?
How to create “dependant” parameter “make, model, year”
Explain why variables called the most powerful component of ssis?
Write a query for primary key constraint with identity key word?
Can group by and orderby be used together?
What is named calculation? : sql server analysis services, ssas
What is the largest component inside a field?
How many clustered indexes there can be on table ?
What are the disadvantages of indexes?
What is the difference between SQL notification and SQL invalidation?
What are views in ms sql server?
