Thread: DISTINCT
Hello, I'd like to select from one table ( contains duplicates ) into a new table. However the new table is exactly the same as the original ( duplicates included ) I think I have a problem with my DISTINCT clause - sql below. It seems the DISTINCT is applied to the whole row not just the 'phone' field. Is the a way I can select the whole row into a new table based on a DISTINCT phone number ? Is the a way I can select the whole row into a new table based on a DISTINCT phone number and state ? Else I'll need to select into a table then select again etc,etc ....to remove duplicates. 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; Thanks Rudi
> 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;
Christopher, Thank you. I though if I'm lucky Chris will be online and will see that one. Kind regards Rudi.