Menggaulimu's Blog

Apa Aja Deh, Suka-Suka Gw

Tag Archives: mysql

Check Duplicate rows on Mysql

Leave a comment Posted by on February 20, 2013 
Table Name= "list"

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
MySql , ,