Thursday, 14 August 2014

Common Mysql Queries

Find Duplicate record:

SELECT q.*, count(*) as cnt FROM `question` as q GROUP BY `question_text` HAVING cnt > 1

No comments :

Post a Comment