Assuming identification_number is a unique (primary) key...
select * from my_table where date_of_birth in (select date_of_birth
from my_table group by date_of_birth having count(*) > 1)
Or - it may be quicker to do...
select * from my_table a where exists (select 'x' from my_table b where
a.da
Thanks. Worked like a charm!
Bruce
[EMAIL PROTECTED] wrote:
Try
SELECT *
FROM mytable
WHERE (identification_number,date_of_birth) IN
(SELECT identification_number
, date_of_birth
FROM mytable m2
GROUP BY identification_number,data_of_birth
Try
SELECT *
FROM mytable
WHERE (identification_number,date_of_birth) IN
(SELECT identification_number
, date_of_birth
FROM mytable m2
GROUP BY identification_number,data_of_birth
HAVING COUNT(*) > 1
)
There are other ways
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 ha
