Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Row Numbers

Row Numbers

From: <cindyclayton_at_att.com>
Date: Mon, 08 Mar 1999 18:03:58 GMT
Message-ID: <7c13e5$eo5$1@nnrp1.dejanews.com>


I am going to pull multiple rows of data for each account_nr. What I need to do is also bring a row number but I need to reset this for each account_nr group. For example..

account_nr       dollars        Row
0000123          $100.00        1
0000123          $150.00        2

0000456          $200.00        1
0000456          $250.00        2
0000456          $350.00        3
0000456          $ 75.00        4

0000789          $225.00        1

etc...

Help will be appreciated!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 08 1999 - 12:03:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US