Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how to get the higher value?
In article <8aliih$ove$1_at_nnrp1.deja.com>,
mitch23_at_hotmail.com wrote:
Join these tables and use greatest function, which returns highest
value.
> I need to to compare the numeric values in two separate select
> statements and get the higher number...Is there a way to do this in
> pure SQL? I can't use PL/SQL as this must be run with Crystal Reports.
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 16 2000 - 13:30:35 CST
![]() |
![]() |