I have a table with three fields:
sometimes there are more than one matching record. A matching record is when (item + customer) is the same.
Is there a way to eliminate all the duplicates besides for the last one. The last one would be the one that was added to the table last. This table is a temporary table with no indexes.