how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
Answer Posted / saleem
SQL query:
select rownum,empno,ename,job,sal from (select
rownum,empno,ename,job,sal from emp rder by sal desc)
group by rownum,empno,ename,job,sal having rownum =&n;
(with this query we will get which highest salary u want)
Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
What does command task mean?
wf dont have integration severances how you can run?
What do you mean by filter transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is domain and gateway node?
What are active transformations.
what is size of u r database?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can we use mapping variables in informatica?
What are the types of presistent cache in look up tr.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are ETL Tools?
How might you approve all mappings in the archive all the while?
Explain the mapping variable usage example in informatica
What is an active transformation?