DISTINCT on multiple fields

From: Matthew Hagerty <matthew(at)venux(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: DISTINCT on multiple fields
Date: 1999-07-01 17:00:23
Message-ID: 4.1.19990701124526.00c0bab0@mail.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message JT Kirkpatrick 1999-07-01 18:18:44 a little conversion problem. . .
Previous Message Clark Joel A1C AMC CSS 1999-07-01 16:51:02 RE: [SQL] Port?