follwing scenario two table using find maximum salary?
table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000
Answer Posted / murali udayagiri
select greatest(sub.emp_max_sal,sub.emp1_max_sal) from
(select (select max(sal) from emp) emp_max_sal,(select max
(sal) from emp1) emp1_max_sal from dual) sub;
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
pmscmd startworkflow -sv
How to extract the informatica rejected data?
What is fact table? Explain the different kinds of facts.
Define sessions in informatica etl?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the use of code page?
What is the Rank index port in Rank transformation?
What are different types of transformations available in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Implementation methodology
How to go to the older version for a mapping?
What are the different versions of informatica?
tell me about your project functionality
What is the session task and command task?
What are the performance considerations when working with aggregator transformation?