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

Answer / ankit kansal

Using Informaica

src-->>sq-->>rnk(sal,bottom,1)
-->>union-->>tgt
src-->>sq-->>rnk(sal,bottom,1)


http://deepinopensource.blogspot.in/

Answer / 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;

Answer / 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);

Answer / murali udayagiri

select greatest(sub.emp_max_sal,sub.emp1_max_sal) from
(select (select max(sal) from emp) emp_max_sal,(select max
(sal) from emp1) emp1_max_sal from dual) sub;



Thanks,
Murali Udayagiri

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

Insert else update option in which situation we will use

4 Answers   HCL,

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

What is the benefit of partitioning a session?

0 Answers  

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

How can we use batches?

0 Answers  

what is threshold error in informatica?

1 Answers   TCS, Wipro,

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

What does refresh system mean, and what are its distinctive choice?

0 Answers  

how to get the first row without using rank t/r?

7 Answers   iGate,

How to implement security measures using repository manager?

0 Answers  

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,