Post reply

using pl/sql table

  • November 20, 2003 at 6:42 pm

    #107382

    hi guys,

    how would i write the following sql statments using pl/sql table?

    SELECT to_char (orderdate, 'yyyymm') as ORDERDATE, SUM(total) as SUM, ordid, custid, shipdate

    FROM ORD

    WHERE ORDERDATE >= to_date ('198701','yyyymm')

    group by orderdate,ordid, custid, shipdate

    having SUM(total) > 1000

    THANKS

  • November 20, 2003 at 6:43 pm

    #482991

    quote:

    hi guys,

    how would i write the following sql statments using pl/sql table--oracle?

    SELECT to_char (orderdate, 'yyyymm') as ORDERDATE, SUM(total) as SUM, ordid, custid, shipdate

    FROM ORD

    WHERE ORDERDATE >= to_date ('198701','yyyymm')

    group by orderdate,ordid, custid, shipdate

    having SUM(total) > 1000

    THANKS

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply