Re: MIN value from UNION?
From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/11/14
Message-ID: <328A6648.16E7_at_jlcomp.demon.co.uk>#1/1
Date: 1996/11/14
Message-ID: <328A6648.16E7_at_jlcomp.demon.co.uk>#1/1
akm wrote:
>
> I'd need to return the MIN value from the following query:
>
> select col1 from tab1
> union
> select col2 from tab2
>
> Thanks!
This will work from 7.1 (ish) onwards.
select min(col1) from
(
select col1 from tab1
union
select col2 from tab2
)
;
Received on Thu Nov 14 1996 - 00:00:00 CET