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