Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
- 4 Answers
- 26228 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / yaseen
Select deptno,distinctsal from emp A where 5= (select count(distinctsal) from emp B where A.sal <= B.sal) groupby deptno
SQ----Rank TR-----Target
Rank t/R ---Group by on Deptno, Top --5
Plz correct if I am wrong
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
Explain about cumulative Sum or moving sum?
What is the reusable transformation?
Mention few power centre client applications with their basic purpose?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is session task and command task?
What is the difference between source qualifier transformations source filter to filter transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the settings that you use to configure the joiner transformation?
What is joiner transformation in informatica?
How to start a workflow using pmcmd command?
What are the main features of Oracle 8i with context to datawarehouse?
What are the transformations that are not supported in mapplet?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Where is metadata stored?
