pierre! amazing it deleted everything. Worked fine.
However, I have a doubt. Imagine I want to make the deletion in a saved query? what should I do?
I tried your code, adding the select statement.
SELECT “ID”, “Fruit”
DELETE FROM “Table2”
WHERE “ID” NOT IN ( SELECT MIN( “ID” ) FROM “Table2” GROUP BY “Fruit” )
It did not worked. Again, show me only the duplicated records, with an “Alias” that says DELETE.
What is wrong?