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
- 20416 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
What is difference between primary key and unique key constraints?
what are the features in cognos8ui
What are shortcuts? Where it can be used? What are the advantages?
Can you define metrics designer?
How to create a cube in Transformer? What is the process? Please mention process thank u
What do you understand by ‘ibm predictive maintenance and quality’?
Can you define cognos impromptu?
What are the steps to import the two data sources in framework manager?
how to explain health care project and which reports we can create in health care doain?
what are the errors faced while bursting the reports and how to solve those errors?
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
Why need staging area database for dwh?
What are the methods by which it non-durable model could be changed into the durable model?
What is a Pivot?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
