Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 60283 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
Do you know nested transaction?
What is service broker? : sql server database administration
what is the difference between a primary key and a unique key? : Sql server database administration
Explain the different types of backups available in sql server? : sql server database administration
What are entities and relationships?
What are the benefits of filtered indexes?
What are system databases into sql server (2005/2008)?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is the return type of executeupdate ()?
Explain cdc and sql injection?
How can I track the changes or identify the latest insert-update-delete from a table?
System requirements for sql server 2005 express edition?
What is de-normalization in sql database administration? Give examples?
Why use stored procedures in sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
