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
- 51102 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / subhranghshu bhattacharjee
first find second largest salary in the emp database:
select min(sal)sal from(select sal from emp order by sal
desc)
where rownum<3
u can find 3rd,4th... so on ,only change rownum
like rownum<4,rownum<5 ... so on
| Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
Explain about sql server login?
What are different types of views?
What is difference between delete and truncate commands?
Explain the stored procedure?
How to concatenate two character strings together?
what are the new features introduced in sql server 2000? : Sql server database administration
How check triggers in sql server?
How to download and install microsoft sql server management studio express?
Explain what is scheduled job and how to create it?
What are the different types of backups avaialabe in sql server 2005?
Explain what is it unwise to create wide clustered index keys?
Explain the purpose of indexes?
Is it possible to have clustered index on separate drive from original table location?
Will the writetext statement activate a trigger?
Define indexes?
