Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / sreenivasa
SELECT DEPTNO, ENAME, SAL FROM EMP A WHERE 4 = (SELECT COUNT
(B.SAL) FROM EMP B WHERE A.SAL < B.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of studio?
What is the information present in the cognos configuration file?
Define catalog in cognos and write its various types?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Can you explain a cognos controller?
Give the advantages of cognos?
what are the dimensions that you have in your current project?list them?
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
how to perform single sign in cognos by using url?
Can you explain new content durability?
How can we Maintain the Cube Security by Category level and Dimension level ?
What is the metric store database?
How is possible this scenario using in type-in prompt.?
What is main advantage datawarehousing over oracle?
Name the types of report?