Posted By

kaartz on 11/08/10


Tagged

mysql records duplicate


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

virendrakryadav
jeremydouglass


select duplicate data from mysql table


 / Published in: MySQL
 

URL: http://www.tutorialspoint.com/mysql/mysql-handling-duplicates.htm

  1. SELECT count(one) as rept, one FROM data8 GROUP BY one HAVING rept > 1

Report this snippet  

You need to login to post a comment.