Postgres Pro
Downloads
Home   >   mailing lists

DISTINCT on multiple fields - Mailing list pgsql-sql

From Matthew Hagerty
Subject DISTINCT on multiple fields
Date
Msg-id 4.1.19990701124526.00c0bab0@mail.venux.net
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Clark Joel A1C AMC CSS
Date:
Subject: RE: [SQL] Port?
Next
From: JT Kirkpatrick
Date:
Subject: a little conversion problem. . .