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
- 51346 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
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Does partitioning improve performance?
What is correlated subquery in sql server?
What are the five characteristics of good data?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Can you pass expressions to function parameters?
What is the openxml statement in sql server?
Difference between Logical Page and Physical Page in SSRS.
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
what is database replication? : Sql server database administration
Why can there be only one clustered index and not more than one?
What are the hotfixes and patches in sql server?
What are the different types of replication are there in sql server 2000?
Explain some stored procedure creating best practices or guidelines?
What are the transaction properties?
