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
- 25945 Views
- CTC, I also Faced
- E-Mail Answers
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
Explain about Informatica server process that how it works relates to mapping variables?
Write the unconnected lookup syntax?
What is transformation?
Do you find any difficulty while working with flat files as source and target?
Enlist the advantages of informatica.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Design a mapping to load the cumulative sum of salaries of employees into target table?
How can we improve session performance in aggregator transformation?
Explain the code page compatibility?
How to extract sap data using informatica?
Can we create two repositories on same database instance in oracle?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the tasks that can be performed using sq?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
