Friday, January 8, 2010

Selecting non-distinct rows in MySQL

Got this here.

SELECT *, COUNT(*) AS count FROM tablename GROUP BY fieldname HAVING count > 1
Posted by Opal at 3:29 PM
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)