select max(sal) from (select max(sal) as sal from table a) union (select

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

Question Posted / dinesh

5 Answers
9684 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / dinesh

select max(sal) from (select max(sal) as sal from table a)
union
(select max(sal) as sal from table b)

ans:
sal
7000
6000

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

whats the logic to load the lower level of granularity of data to fact table.

2276

What is joiner change?

1148

what are factless facts? And in which scenario will you use such kinds of fact tables.

1811

What is persistent lookup cache?

1035

Explain the shared cache and re-cache?

1121

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1923

What is a rank transform?

1087

What is update strategy transform?

1112

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

2748

How can we use batches?

1026

explain about unit testing? in real time?

2209

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2174

What is meant by lookup transformation? Explain the types of lookup transformation?

952

Differentiate between Load Manager and DTM?

2160

What are the tasks that source qualifier perform?

1106