Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / vsandhyana
Hi Hashmatulla Baig,
I think your query will not give the desired output. it
should be modify please refer below for the same.
SELECT empno, sal
FROM
(
select empno, sal, (ROW_number() OVER (order by sal desc)) R
from emp
order by sal desc
)
WHERE R = 5;
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do we drill through from a powerplay cube to reportnet?\
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what are the special features in cognos reportnet?
Write some methods to apply securities in framework manager model?
How can create users and permissions in cognos?
-----------------What is Direct and Conventional loading?
explain how to create powerplay reports?
What is the complex report you faced in real time?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is the difference between Open Connection command ang Open Session Command?
What do you mean by drill through report?
What do you mean by query studio?
Define the cognos reporting tool?
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.
------------- How to identify the Revenue Column in Report?