Re: DISTINCT

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: DISTINCT
Date: 2002-09-13 02:30:47
Message-ID: GNELIHDDFBOCMGBFGEFOIEDICEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> SELECT
> DISTINCT phone,
> company_name,
> address,
> state,
> idc_desc_1,
> street_number,
> street_name,
> street_xtra,
> suburb,
> postcode,
> area_code,
> ac_phone,
> fax_area_code,
> fax_phone,
> fax_ac_phone,
> latitude,
> longitude
> INTO export_temp
> FROM export;

SELECT
DISTINCT ON (phone)
phone,
company_name,
address,
state,
idc_desc_1,
street_number,
street_name,
street_xtra,
suburb,
postcode,
area_code,
ac_phone,
fax_area_code,
fax_phone,
fax_ac_phone,
latitude,
longitude
INTO export_temp
FROM export;

In response to

  • DISTINCT at 2002-09-13 02:31:07 from Rudi Starcevic

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2002-09-13 02:31:07 DISTINCT
Previous Message James Orr 2002-09-12 22:10:01 Re: [SQL] Latitude / Longitude