Re: Find double (not uniqe) entries in a table

[Roland Bouman]

assuming id is always unique

select id
, name
, city
from table1 t1
where exists (
select null
from table1 t2
where t1.name = t2.name
and t1.id <> t2.id
)

if id by itself is not unique, you can add the city field too:

select id
, name
, city
from table1 t1
where exists (
select null
from table1 t2
where t1.name = t2.name
and (t1.id <> t2.id
or t1.city <> t2.city)
)