advanced code snippet search

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

Expand | Embed | Plain Text 
  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.