Max value in select statement

[dsrawat]

Hi,
My requirement is that i have to get the MAX or Greatest of the three values from three tables and replace each value with the Hightest value.

Example :

select
age2 = c.age - b.age,
age3 = a.age - b.age,
age1 = a.age
from a , b , c
where a.name = b.name
and a.deptid = c.deptid

Now my requirement is that to check which age is greatest ( heightest )
among age1 , age2 , age3 and then assign each age i.e. age1 , age2 and age3
with that heightest age.


I have to do it in SQL only . No pl/sql please


Regards

Rawat

[r035198x]

Hi,
My requirement is that i have to get the MAX or Greatest of the three values from three tables and replace each value with the Hightest value.

Example :

select
age2 = c.age - b.age,
age3 = a.age - b.age,
age1 = a.age
from a , b , c
where a.name = b.name
and a.deptid = c.deptid

Now my requirement is that to check which age is greatest ( heightest )
among age1 , age2 , age3 and then assign each age i.e. age1 , age2 and age3
with that heightest age.


I have to do it in SQL only . No pl/sql please


Regards

Rawat

Sounds like homework. Do you know how to get the maximum of one age e.g age1?