Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17541 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vsandhyana
select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc
Thanks
Vikram Sandhyana
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Define query studio?
What do you understand by the term 'dynamic cube'?
------------ Diff b/w MemberCaption and MemberDescription?
Can you define framework manager?
How do you improve the performance of the Cognos Analytics report
Can you explain dynamic query mode?
What is set to be Cognos configuration?
How do you Parametermap variables in Quiries?
What is cognos powerhouse?
What do you mean by drill through report?
Why need staging area database for dwh?
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.
difference between impromptu and cognos8
what is requery in cognos?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
