Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16667 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / hashmatulla baig
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 ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a Transformer?
What is called Cognos powerplay?
WHAT ARE THE DISTNICT VARIABLES?
tell me two or three issues from client side and how to solve those issues?
Give the advantages of cognos?
what are the special features in cognos reportnet?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is a Folder?
What is a Cube?
---------------Tell me about DWH Concepts?
Can you explain the advantage of using shortcuts?
What is the metric store database?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
difference between impromptu and cognos8
