Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT firstname, lastname, list.address FROM list
- INNER JOIN (SELECT address FROM list
- GROUP BY address HAVING count(id) > 1) dup ON list.address = dup.address
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement