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
- 51535 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
Are connections to sql server encrypted?
Why use stored procedures in sql server?
Do you know what are the reporting services components?
Can I disable or restrict ssrs export formats (rendering formats)?
What language is sql server written in?
List few advantages of stored procedure.
Which rendering formats are affected by the pagesize properties?
Explain having clause?
Differentiate between a local and a global temporary table?
List the different types of collation sensitivities in sql server?
How do you manipulate data?
What is a periodical index?
What is t-sql script to take database offline – take database online.
What is trigger explain with program?
Explain difference between cross join and full outer join?
