I would like to insert a sequence number into a query that currently returns 7367 rows.
Here's what it looks like now:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID_NUM
[/TD]
[TD]DTE_FIN_TRANS_RCV
[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]9/27/2012[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]7/10/2012[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]7/2/1999[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]9/22/1999[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]10/21/1999[/TD]
[/TR]
</tbody>[/TABLE]
Here's the desired outcome with sequences:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID_NUM
[/TD]
[TD]DTE_FIN_TRANS_RCV
[/TD]
[TD]SEQUENCE
[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]9/27/2012[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]7/10/2012[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]7/2/1999[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]9/22/1999[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]10/21/1999[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID_NUM
[/TD]
[TD]DTE_FIN_TRANS_RCV
[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]9/27/2012[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]7/10/2012[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]7/2/1999[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]9/22/1999[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]10/21/1999[/TD]
[/TR]
</tbody>[/TABLE]
Here's the desired outcome with sequences:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID_NUM
[/TD]
[TD]DTE_FIN_TRANS_RCV
[/TD]
[TD]SEQUENCE
[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]9/27/2012[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1322[/TD]
[TD]7/10/2012[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]7/2/1999[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]9/22/1999[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1011[/TD]
[TD]10/21/1999[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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.