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
- 58929 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
Explain why variables called the most powerful component of ssis?
What is after dml trigger?
How to execute a stored procedure in ms sql server?
What the different types of Replication and why are they used?
what stored procedure can you use to display the current processes? : Sql server administration
what are the core components of SSRS?
How can you stop stored procedures from recompiling?
How exceptions can be handled in sql server programming?
can SSRS reports Cache results?
Differentiate between a primary key and a unique key.
What is 2nf in normalization?
What are the benefits of filtered indexes?
List few advantages of stored procedure.
explain what is raid and what are different types of raid configurations? : Sql server database administration
Does hive support indexing?
