Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / dhanu
SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What do you understand by the term 'dynamic cube'?
What junk dimension contains?
What do you mean by drill through report?
Define metrics studio?
Can you define snapshot?
What is Online View?
What is the difference between low affinity and high affinity connections?
What is the advantage of using shortcuts?
What are cognos connection initial page components?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is Fullouterjoin?
What is the difference between Open Connection command ang Open Session Command?
what is the difference between native sql and cognos sql?