I would like to insert a sequence number into a query that currently returns 7367 rows.
Here's what it looks like now:
<tbody>
</tbody>
Here's the desired outcome with sequences:
<tbody>
</tbody>
All I need is a way to number rows with a value higher than the previous for that particular ID_NUM. Any assistance with achieving this will be most appreciated. Thank you.
Here's what it looks like now:
ID_NUM | DTE_FIN_TRANS_RCV |
1322 | 9/27/2012 |
1322 | 7/10/2012 |
1011 | 7/2/1999 |
1011 | 9/22/1999 |
1011 | 10/21/1999 |
<tbody>
</tbody>
Here's the desired outcome with sequences:
ID_NUM | DTE_FIN_TRANS_RCV | SEQUENCE |
1322 | 9/27/2012 | 1 |
1322 | 7/10/2012 | 2 |
1011 | 7/2/1999 | 1 |
1011 | 9/22/1999 | 2 |
1011 | 10/21/1999 | 3 |
<tbody>
</tbody>
All I need is a way to number rows with a value higher than the previous for that particular ID_NUM. Any assistance with achieving this will be most appreciated. Thank you.