Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16468 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pradeep nagireddy
select *
from(select rownum r,sal from emp order by sal desc)
where rownum = 5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cognos powerhouse?
what are the names of the reports that you prepared?
Why cognos scenario is used?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Can you define dimension?
Can you define cognos impromptu?
What is meant by alternate drill down with ex?
What are products of cognos?
what are the features in cognos8ui
What is a dimension?
What are the components of report net?
faq's on cognos
How to join multiple db in catalog?
is there any difference between operational database and data base?if yes what r they?
What is difference between content store and content manager?
