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
- 8274 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gd
select max(sal) from table a,table b in (select
a.id,a.name,a.sal,b.id.b.sal from table a, tableb where
a.id=b.id);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What are the popular informatica products?
What is decode in static cache?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Where do we use mapping variables in informatica?
How you prepared reports for OLAP?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Make a note of the quantity vaults made in informatica?
What are the components of workflow manager?
What are the data movement modes in informatica?
What is exclusive and normal mode for repository services?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is aggregate cache in aggregator transformation?
What are the various types of transformation?
What are the components of Informatica? And what is the purpose of each?
