Hello,
I have a table(Table1) and have two fields. Field1 and Field2. Field2 is the field that has the values. There can be duplicate values in Field1. for example:
Field1 Field2
Mark 1
Mark 2
Mark 3
I want to remove the smallest values from the table and only keep the max value.
Thanks for your help