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
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
Does the order of columns in update statements matter?
Explain how dts is used to extract, transform and consolidate data?
How many types of the database links?
What factors you will consider calculating the storage requirement for that view?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What are the different types of subquery?
Can we add a cpu to sql server?
What are the dis_advantages of stored procedures, triggers, indexes?
What are the lambda triggers?
What happens if you add a new index to large table?
What is the use of keyword with encryption.
What is the difference RDBMS and Graph Database?
Do you know what are the differences between lost updates and uncommitted dependencies?
Explain error handling in ssis?
How do we Backup SQL Azure Data?