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
- 21392 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 do you understand by the term 'dynamic cube'?
Explain the characteristics of cognos?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
how you migrate reports to cognos 8 from previous versions?
Can you define bitmap index?
Please explain the different stages in creating a report in cognos report net?
How do you improve the performance of the Cognos Analytics report
What is zero-foot print?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is cognos reporting tool?
Give the advantages of cognos?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
what are the dimensions that you have in your current project?list them?
