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
- 51082 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / amar banerjee
sol1> select MAX(salary) from emp where salary< (select MAX(salary) from emp);
sol2> select salary from emp sort by salary desc limit 1,1;
for finding nth position
select salary from emp sort by salary desc limit n-1,1;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are data regions?
Can We Use Data-grids For Our Report In Ssrs?
Explain try...catch with sql server?
How to find the source of a table in sql server?
what are the important architecture components of SSRS?
What is normalization of database? What are its benefits?
query processing
what is the difference between openrowset and openquery?
What happens if date-only values are provided as date and time literals?
How do you make a trace?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Define cursor locking
What is the difference between ddl and dml?
Do you know how to implement service broker?
