Re: [SQL] Help needed in skipping column for copy command

COPY D_2147483927_2147484848_TAB ( CP , CPR , CHOUSENO , CSTREET , CLOCALITY , CCITY , CPROVINCE , CCOUNTRY , CZIP ) FROM 'one.txt' WITH DELIMITER ',' QUOTE '' csv HEADER; On Mon, Jan 17, 2011 at 7:59 AM, Amar

Re: [SQL] return records with more than one occurrences

SELECT t.id t.id_table1 t.name FROM Table2 t INNER JOIN (SELECT t_inner.id_table1 FROM Table2 t_inner GROUP BY 1 HAVING COUNT(*) 1) temp ON temp.id_table1 = t.id_table1 ; On Wed, Jan 5, 2011 at 8:18 AM, Tarsis Lima tarsis.l...@gmail.com wrote: how would the