numbering a column according to group

From: Leigh <leighlhg_at_hotmail.com>
Date: 9 Jul 2003 21:35:06 -0700
Message-ID: <b8cf9ab1.0307092035.78ce99d8@posting.google.com>

HELP! Anyone SQL gurus out there please help me with a query update to a table:

I need to update a column in a table sequentially base on the date and group by the customer number and the order item with data as such:

cust_no, order_item, order_date column_to_update

111        AAA        01/20/02    1
111        AAA        08/20/02    2
111        AAA        12/20/02    3
333        AAA        01/15/02    1
333        AAA        03/26/02    2
555        BBB        01/06/02    1
555        BBB        03/06/02    2
555        BBB        04/26/02    3
555        BBB        05/26/02    4

I only have oracle 8.1.7 Standard edition: so no analytical feature.

Thanks in advanced. Received on Wed Jul 09 2003 - 23:35:06 CDT