Hi all,
I want to create a view in oracle to only show the last record in a group.
Example data
REF_NUM TRAN_DATE TRAN_NUMBER
10921671 02/01/2003 000009
10921671 10/01/2003 001858
10921671 13/01/2003 000372
0224529015 02/01/2003 009921
0224529015 10/01/2003 000110
0224529015 14/01/2003 000011
The view should only show:
REF_NUM TRAN_DATE TRAN_NUMBER
10921671 13/01/2003 000372
0224529015 14/01/2003 000011
Please help me, it's driving me slowly crazy!!
Reebo
Scotland (Sunny with a Smile)
I want to create a view in oracle to only show the last record in a group.
Example data
REF_NUM TRAN_DATE TRAN_NUMBER
10921671 02/01/2003 000009
10921671 10/01/2003 001858
10921671 13/01/2003 000372
0224529015 02/01/2003 009921
0224529015 10/01/2003 000110
0224529015 14/01/2003 000011
The view should only show:
REF_NUM TRAN_DATE TRAN_NUMBER
10921671 13/01/2003 000372
0224529015 14/01/2003 000011
Please help me, it's driving me slowly crazy!!
Reebo
Scotland (Sunny with a Smile)