Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17532 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / karthik murugeshan
SELECT B.Salary FROM (SELECT Salary FROM EMP)A,(SELECT
Salary FROM EMP)B
WHERE A.Salary>=B.Salary
GROUP BY B.Salary
HAVING COUNT(B.Salary)=5
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What do you understand by the term 'aggregate advisor?'
------------------What is Inline Query?
How to do Performence Tunning in Cognos Reports?
What is the use of Cognos scenario?
Define report item?
What are the components of the report studio?
What is Additive function?
How do we drill through from a powerplay cube to reportnet?\
What is a Folder?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is the difference between a cascading report and drill through report?
What is the difference between a cascading report and drill through the report?
How the Bursting happens in same report and how to Print the bursting Report?
Can you define a query subject?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
