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
- 9835 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
Informatica Checkpoints
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to load last n records of file into target table - informatica
How we can create indexes after completing the loan process?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is primary and backup node?
Define pmcmd command?
What is aggregate cache in aggregator transformation?
What is an aggregator transformation?
How do you convert single row from source into three rows into target?
How can we use mapping variables in informatica? Where do we use them?
how we can load rejected record's at run time?(not through bad files)
What is persistent lookup cache?
what is the difference between informatica6.1 and infomatica7.1
How to go to the older version for a mapping?
