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
- 9502 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / asdf
select id,name,max(sal) from table a;
select id,max(sal) from table b;
if u want to join two tables
select id,sal from table a,table b where a.id=b.id;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain the tuning lookup transformation - informatica
How we can use union transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is substr in informatica?
Define mapplet?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to load a Dimension ? and how to load a fact table?
Could you explain what is enterprise data warehouse?
What are session parameters ? How do you set them?
Where are the source flat files kept before running the session?
What is data movement mode in Informatica and difference between them?
what are 3 tech challenges/ common issues you face?
Explain the different dimensions.
