Re: DISTINCT
| От | Christopher Kings-Lynne |
|---|---|
| Тема | Re: DISTINCT |
| Дата | |
| Msg-id | GNELIHDDFBOCMGBFGEFOIEDICEAA.chriskl@familyhealth.com.au обсуждение исходный текст |
| Ответ на | DISTINCT (Rudi Starcevic <rudi@oasis.net.au>) |
| Список | 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;
В списке pgsql-sql по дате отправления: