Request a Demo
Home   >   mailing lists

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

From Russell Galyon
Subject Re: return records with more than one occurrences
Date
Msg-id AANLkTi=DkWUsuG979oCQK6O1BuhNox4zjqpKGfLL-CjP@mail.gmail.com
Whole thread
In response to return records with more than one occurrences  (Tarsis Lima <tarsis.lima@gmail.com>)
List pgsql-sql
Tree view
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.lima@gmail.com> 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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: pattern matching with dates?
Next
From: Jasen Betts
Date:
Subject: Re: pattern matching with dates?