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
- 51190 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / subhranghshu bhattacharjee
another way u can find 2nd largest salary,3rd largest
salary ... so on
select sal from(select sal from emp order by sal desc)
where rownum<3
minus
select sal from(select sal from emp order by sal desc)
where rownum<2
only change rownum to find various largest salary
Subhranghshu Bhattacharjee
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How you can add messages to the nt event log from within a stored procedure?
What are data files?
Tell me what is the order in which the sql query is executed?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
define and explain the differences between clustered and non-clustered indexes.
What is the default port for SQL Server over a firewall?
What is the purpose of the master database?
How many databases Microsoft SQL server provides?
List the advantages of using stored procedures?
What stored by the model?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is the default schema of your login session in ms sql server?
Define cursor locking
What are the types of sql server?
