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
- 55028 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
How to find table changes in sql server?
What is difference between clustered and non clustered index?
What is difference between drop truncate and delete?
What do you understand by triggers and mention the different types of it?
What is index fragmentation in ms sql server?
How you can get a list of all the table constraints in a database?
How to concatenate two binary strings together?
How to turn off warning messages during php execution?
What is triggers and stored procedures?
How to convert character strings into numeric values?
role of sql sever 2005 in database rather than any other database
How to delete duplicate records based on single column from a table?
What is view in sql?
What are the basic features of a trigger in ms sql server?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
