| From: | "Kall, Bruce A(dot)" <kall(at)mayo(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SELECT duplicates in a table |
| Date: | 2004-11-22 17:37:17 |
| Message-ID: | 41A223CD.6040709@mayo.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've look for a solution to this, but have only been able to find
solutions to delete duplicate entries in a table by deleting entries not
returned by SELECT DISTINCT.
What sql should I use to SELECT entries in a table that have two
particular column values that match?
For example, my_table has
name, phone number, identification_number, zip code, date of birth, and city
I want to SELECT rows from this table that have the same values in
identification and date of birth (duplicates) so I can have the user
look at them in order to figure out which one to delete.
I tried something like:
$db_sql = "SELECT * FROM my_table GROUP BY identification_number
HAVING count(date_of_birth) > 1 ORDER BY name"
but that doesn't seem to work.
Thanks,
Bruce
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vhikida | 2004-11-22 17:56:00 | Re: SELECT duplicates in a table |
| Previous Message | Scott Nixon | 2004-11-22 16:44:36 | Re: Help with syntax for timestamp addition |