Hello,
I am having trouble finding a video or an example query in how to delete all duplicates and leave just 1 record each.
Table name is Table1, the field that I'm looking at that can have duplicates is "LON"
For example
LON
1111
1111
1222
1234
1255
I just want to keep one of the 1111's