Thread: DISTINCT on multiple fields

DISTINCT on multiple fields

From
Matthew Hagerty
Date:
Greetings,

I need a query that will remove duplicate records if three fields are the
same, i.e. the name, address, and VIN.  I have been messing around with
DISTINCT and DISTINCT ON but I cannot get the results I'm looking for.

Thank you,
Matthew