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
- 20917 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / dhanu
SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to join multiple db in catalog?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What are the advantages of shortcuts?
What do you mean by query studio?
What is a Query Subject?
Can you explain new content durability?
2. What functional area you worked on.
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
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.
What is the difference between drill through, drill across?
How can I test reports in cagonos?
Why are meta service important then other services?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is the difference between Section and Section using
Master/Detail in Cognos 8 Report Studio? I tried these both
options many times on lists and crosstabs, but dint find any
difference. So please give the answer in detail with example. what is the difference between native sql and cognos sql?
