I've have a duplicate query running on a table containing 1000s of records. I need to retain the highest batch number from the property reference group (the duplicate field). Basically keep the records in red in the example below...
Property Reference
Batch
1070
354
1070
491
1070
565
1070
581
1070
582
1074
491
1074
565
1074
581
1074
682
1075
353
1075
354
1075
491
Hope someone can help. This is my first post on the forum.
Many thanks in advance.