Need Help with PL/SQL
From: <atyagi_at_mc.xerox.com>
Date: 1996/10/22
Message-ID: <NEWTNews.845981814.9797.atyagi_at_sgeier.wsp>#1/1
Date: 1996/10/22
Message-ID: <NEWTNews.845981814.9797.atyagi_at_sgeier.wsp>#1/1
Hi everybody,
Thanks to all those who helped me last time. I have another question
for you! I have written this query and I want to restrict the total number
of records returned to exactly 100. I am trying and I can not make it work. I
will greatly appreciate any suggestion.
SELECT EO_SHIPPED.SHIP_DATE, COUNT(EO_SHIPPED.ORDERNUM)
FROM WHISC.EO_SHIPPED EO_SHIPPED
You can email me directly to atyagi_at_mc.xerox.com or post the reply
WHERE (EO_SHIPPED.SHIP_DATE >=ADD_MONTHS(SYSDATE,-5))
AND (TO_CHAR(EO_SHIPPED.SHIP_DATE,'DAY') NOT LIKE 'S%')
GROUP BY SHIP_DATE;
Thanks again
Amit Tyagi
Xerox Corp. Received on Tue Oct 22 1996 - 00:00:00 CEST