Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20890 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What are various types of gateways in cognos?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Why cognos decision stream is used?
What is the difference between group and associare?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What are all the types of report?
What are the different types of reports present in cognos?
What are the types of security?
what are slowly changing dimensions? Why we are used scd?
How do you improve the performance of the Cognos Analytics report
what is catalog and types of catalogs in cagnos and which is better?
Can you explain the advantage of using shortcuts?
Can you define framework manager?
What is the deployment requirements used in cognos?
