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
- 55034 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
When would you use the stored procedures or functions?
What is sharding?
Explain the benefits of user-defined functions?
Explain view in sql server?
How do I install sql server?
Explain the microsoft sql server delete command?
How to get the definition of a user defined function back?
If no size is defined while creating the database, what size will the database have?
What is CTE in SQL
Explain the types of indexes.
What are data driven subscriptions?
How will you make an attribute not process? : sql server analysis services, ssas
What is difference between order by and group by?
What is create statement?
How to fine-tune reports?
