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
- 20386 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 DB View and Bus View?
What is drill down and slicing and dicing whats the difference between them?
where you can save the report net documentation in our local system?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
----------------Diff b/w Dimensional modeling and Relational modeling?
Can you define drill across?
What are all the components of Report Studio?
How can create users and permissions in cognos?
What are the services provided in cognos 8?
What is a dimension?
what is model and say about process how to create model and how to test model?
5. Which type of report you build more, list, crosstab or chart and why?
what is a prompt value in report studio and variables ?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is the function of cognos dispatcher?
