Postgres Pro
Downloads
Home   >   mailing lists

Re: return records with more than one occurrences - Mailing list pgsql-sql

From Jasmin Dizdarevic
Subject Re: return records with more than one occurrences
Date
Msg-id AANLkTikOHwV56NvXZBSZ19yWOW_kVYGm=bqaik-k07pS@mail.gmail.com
Whole thread Raw
In response to return records with more than one occurrences  (Tarsis Lima <tarsis.lima@gmail.com>)
List pgsql-sql
Tree view
Hi, 

this is a good point to start.

select t2.* from table2 t2
inner join (
  select id from table1 
  group by id
  having count(*) > 1
) t1 on t2.id_table1 = t1.id

2011/1/5 Tarsis Lima <tarsis.lima@gmail.com>
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

pgsql-sql by date:

Previous
From: "Good, Thomas"
Date:
Subject: pattern matching with dates?
Next
From: Samuel Gendler
Date:
Subject: Re: pattern matching with dates?