select max(sal) from table a,table b in (select a.id,a.name,a.sal,b.id.b.s

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 / gd

5 Answers
9500 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

Please Help Members By Posting Answers For Below Questions

Write the program through which the records can be updated?

938

Under which circumstances, informatica server creates reject files?

1028

Explain joiner transformation in informatica

1077

have u done any performance tuning? how u ll do?

2249

What is meant by LDAP users?

1114

Explain lookup transformation is active in informatica

1038

Where is metadata stored?

1045

What are the informatica performance improvement tips

1019

What are active and passive transformations?

1023

update strategy transformation in informatica

1018

tell me the rules and responsblites in our project(my project is development)

1875

How to create a non-reusable instance of reusable transformations?

1061

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1854

What are batches?

1012

Separate from a database, an information bazaar, and an information stockroom?

1016