Category Archives: mysql

How to find duplicate rows from query ?

If you want to find duplicate rows from your table use the following query. SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1SELECT column1,column2 COUNT(*) users GROUP BY column1, column2 HAVING COUNT(*) > 1 Following are steps : To test the above query on sample table Step1 : First of all you need a table (Assuming you have… Read More »