PostgreSQL

[0913 nobodyさん 03/02/13 22:43 ID:???]

SELECT email, name
FROM users
GROUP BY email
HAVING count(*) > 1


email name
-------------------
[e-mail] aaa
[e-mail] bbb
…

こんな感じかな？