Re: Need Help with PL/SQL
From: Kevin S. DeWitt <dewitt_at_interramp.com>
Date: 1996/10/23
Message-ID: <326E2401.4E24_at_interramp.com>#1/1
>
Date: 1996/10/23
Message-ID: <326E2401.4E24_at_interramp.com>#1/1
Thomas J. Kyte wrote:
>
> In 7.1 and up you can simply:
>
> select *
> from (
> SELECT EO_SHIPPED.SHIP_DATE, COUNT(EO_SHIPPED.ORDERNUM) CNT
> FROM WHISC.EO_SHIPPED EO_SHIPPED
> WHERE (EO_SHIPPED.SHIP_DATE
>=ADD_MONTHS(SYSDATE,-5))> where rownum <= 100
> AND (TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY') NOT LIKE 'S%')
> GROUP BY SHIP_DATE )
>
Thomas,
Will your solution work if there is an ORDER BY involved? My understanding of rownum is that it is derived prior to the sort.
Thanks,
Kevin DeWitt
Pgh, PA
Received on Wed Oct 23 1996 - 00:00:00 CEST