Postgres Pro
Downloads
Home   >   mailing lists

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

From Tarsis Lima
Subject return records with more than one occurrences
Date
Msg-id d7cb6a09-b376-4e46-ba2b-3dfe82a90d77@c2g2000yqc.googlegroups.com
Whole thread Raw
Responses Re: return records with more than one occurrences
Re: return records with more than one occurrences
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: explicit casts
Next
From: "Good, Thomas"
Date:
Subject: pattern matching with dates?