What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sree
select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);
| Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
what is $$$$?
Explain constraint based loading in informatica
What is olap (on-line analytical processing?
explain one complex mapping with logic? sales project?
Target increases every day even though no new record was inserted
How to load the data from a flat file into the target where the source flat file name changes daily?
Does an informatica transformation support only aggregate expressions?
Implementation methodology
What is mapplet in informatica?
What are the different transaction levels available in transaction control transformation?
How can we create index after completion of load process?
What is the difference between informatics 7x and 8x and what is latest version?
how to load dimension table and fact table. plz tell me the steps.
Explain target update override in informatica
Enlist few areas or real-time situations where informatica is required.