Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20514 Views
- HCL, I also Faced
- E-Mail Answers
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
What is the complex report you faced in real time?
7. What is performance tuning?
please please give me some banking calculations in framework manager.
what is the role of cognos comsultant?what actually it means?pls reply
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
How do we drill through from a powerplay cube to reportnet?\
How do you improve the performance of the Cognos Analytics report
Can you explain the advantage of using shortcuts?
What are types of batch available in cognos?
Why need staging area database for dwh?
4. How many dimensions did you use in your reports?
What is model filter?
What is looping and how to avoid it in framework manager?
Explain the difference between powerplay transformer and power play reports?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
