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
- 21419 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
What is meant by junk dimension?
Can you define cognos impromptu?
how can I test reports in cagnos?
------------ Diff b/w MemberCaption and MemberDescription?
What is Bitmap Index?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What is a Pivot?
what is the difference between native sql and cognos sql?
is there any difference between operational database and data base?if yes what r they?
can we insert all types of charts in a list report? what r the realtime prompts?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Can you define folder?
What is the difference between Standard and Metrics folder?
Can you define transformer?
