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
- 61259 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 create prepared statements using odbc_prepare()?
What are information schema views?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the order by used for?
How do I find my localdb version?
Can you please explain the difference between primary keys and foreign keys?
What function does a database engine serve in the sql server?
How to loop through returning rows?
What is table-valued sub query?
What is partition, how will you implement it? : sql server analysis services, ssas
Does the unique constraint create an index?
What are the pre-defined functions in the sql server?
Is oracle faster than sql server?
Is it possible to create trigger on views?
Where actually sql azure database is hosted?
