Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17540 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
Explain the difference between powerplay transformer and power play reports?
What is difference between page break and section report?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
what do u mean by bridge group? where we r using this one?
------------- How to identify the Revenue Column in Report?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
How to do Performence Tunning in Cognos Reports?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What do you understand by the term 'aggregate advisor?'
What are the different types of important services used in cognos?
What are the main services provided by application tier?
What is called materialized view?
Can we test the report other than manual testing?
Tell me about Dnamic and Static Dashboards?
Write types of folders present in cognos?
