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

[Russell Galyon]

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  wrote:

> how would the SELECT to  return only records with more than one
> occurrences  of id_table1? example:
>  -- Table1
>  -- id --
> -
>1
>2
>
>
> -- Table2
>   id  --- | id_table1 | name
>  --
>   4   | -  1 -- |   Tom
>   5   | -  1 -- |   Luci
>   6   | -  2 -- |  Cleber   -->this can not return
>
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

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

[Russell Galyon]

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 Dhole  wrote:

>   I have table created as follows
>
>
>
>
>
> CREATE TABLE D_2147483927_2147484848_TAB(
>
> CP  VARCHAR(256) ,
>
> CPR VARCHAR(256) ,
>
> CHOUSENO VARCHAR(256) ,
>
> CSTREET VARCHAR(256) ,
>
> CLOCALITY VARCHAR(256) ,
>
> CCITY VARCHAR(256) ,
>
> CPROVINCE VARCHAR(256) ,
>
> CCOUNTRY VARCHAR(256) ,
>
> CZIP VARCHAR(256) ,
>
> CCO VARCHAR(256) )
>
>
>
> I am using copy command to copy the content of file into the table.
> (one.txt)
>
>
>
> PR,PRO,HOUSENO,STREET,LOCALITY,CITY,PROVINCE,COUNTRY,ZIP,CON
>
> ,,A-24 Siddi vihar apt.,Near Krishna Chowk,New Sanghvi,Pune,MH,India,411027
>
>
>
>
>
> In the above data, data for last column is missing.
>
>
>
>
>
> copy D_2147483927_2147484848_TAB from 'D:/work/one.txt' with delimiter as
> ',' quote '"'  csv HEADER  ;
>
>
>
>
>
> I get the following error as
>
>
>
> ERROR:  missing data for column "ccontains"
>
> CONTEXT:  COPY d_2147483927_2147484848_tab, line 2: "q,q,A-24 Siddi vihar
> apt.,
>
> Near Krishna Chowk,New Sanghvi,Pune,MH,India,411027 "
>
>
>
> Can any one please tell me how can I make copy command to ignore the data
> missing column ? as the data in file is unknown so it column name is which
> is missing is not known in advance.
>
>
>
> Thanks
>
> Amar
>
>
>