Extract one instance of record.
Posted: Tue Oct 16, 2012 11:03 am
Dear friend
I want a methode to extract one instance of records which contain same data on coloumn 11 to 15. For example if SORTIN like below:
Out put must be below:
I want a methode to extract one instance of records which contain same data on coloumn 11 to 15. For example if SORTIN like below:
ABCDE1000077001
BACDE1000077001
CBADE1000077001
DCBAE1000077002
EDCBA1000077002
ABCDE1000077003
BACDE1000077001
CBADE1000077001
DCBAE1000077002
EDCBA1000077002
ABCDE1000077003
Out put must be below:
ABCDE1000077001
DCBAE1000077002
ABCDE1000077003
DCBAE1000077002
ABCDE1000077003