Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16668 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
Define metrics studio?
What is the difference between the standard and metrics folder?
How can I schedule reports in cognos?
How can we Maintain the Cube Security by Category level and Dimension level ?
--------------Diff b/w ODS and OLAP?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
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
how to merge 2 crosstabs thans
What is drill down and slicing and dicing whats the difference between them?
What is meant by junk dimension?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is Fullouterjoin?
Define query studio?
Write some methods to apply securities in framework manager model?
how you create security to reports?
