Re: using the result of a partial sum in a where clause

From: Adrián Garrido <agarrido_at_memory-set.es>
Date: Tue, 18 Jun 2002 19:59:51 +0200
Message-ID: <aensds$8be$1@nsnmrro2-gest.nuria.telefonica-data.net>

"Knut Talman" <knut.talman_at_mytoys.de> escribió en el mensaje news:3D0F73B5.96C8AD04_at_mytoys.de...

>Oracle version? And why should the query return 01/09/2002? All other dates
past
>it also meet your requirement. Are you looking for the first date which has
>sum(value)>=parameter?
>
>Regards,
>
>Knut

Sorry, I forgot to explain that I need only the first date that match the condition. I am using Oracle8i Enterprise Edition Release 8.1.7.3.0.

Thanks again and regards
Adrián Garrido Received on Tue Jun 18 2002 - 12:59:51 CDT