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
What is a filter transformation?
What is the sequence generator transformation in informatica?
Explain constraint based loading in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is rank transformation in informatica
Repository user profiles
Define Pmrep command?
What is intricate mapping?
What does refresh system mean, and what are its distinctive choice?
What are the various types of transformation?
What are ETL Tools?
define galaxy repository in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
Is it possible to define a single node as a Gateway node as well as worker node?
Different circumstance which drives informatica server to expel records?