Wednesday, 15 July 2015

How to get Duplicate Record From Mysql Database ?

Use this query to get duplicate record-

SELECT mobile, count(id) as total_count FROM servicecall
GROUP BY mobile HAVING total_count > 1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)