Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 9700 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
How to extract sap data using informatica? What is abap? What are idocs?
Why update strategy and union transformations are active?
What is mapplet in informatica?
Can anyone tell me the new features in Informatica 9 Version?
which one is better performance wise joiner or look up
How you prepared reports for OLAP?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Which transformation should we use to normalise the COBOL and relational sources?
How big was your fact table
Separate from an archive server and a powerhouse?
what is the hint? how to use it to reduce the query processing in program?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the need for an etl tool?
What are the databases that informatica can connect to windows?
How many dimensions are there in informatica?
