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
- 26030 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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How many ways a relational source definition can be updated and what are they?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the command used to run a batch?
What are connected or unconnected transformations?
How to generate sequence numbers without using the sequence generator transformation?
What are the types of caches in lookup?
what is informatica metadata?
How do you load unique records into one target table and duplicate records into a different target table?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to implement security measures using repository manager?
How do you handle two sessions in Informatica
How to create Target definition for flat files?
Quickly characterize reusable change?
What is a surrogate key?
