Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 18592 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
Can you define folder?
What are the types of studio present in Cognos?
How Metrics Studio is better than Report Studio?
Define query items?
What is a Query Subject?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Can you define a catalog and types of catalogs in cognos?
What is a Cube?
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
What are query items?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What is the advantage of using shortcuts?
i was asked what are the caluclations done by you in your report? plz give reply
Why is auto-regression used in forecasting used on cognos platform?
