Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to get the higher value?

Re: how to get the higher value?

From: <afilonov_at_pro-ns.net>
Date: Thu, 16 Mar 2000 19:30:35 GMT
Message-ID: <8arcor$21r$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US