Skip to main content

Return to Answer

deleted 24 characters in body
Source Link
George G
George G
  • 7.7k
  • 12
  • 48
  • 62

we can found the duplicates depends on more then one fields also.For those cases you can use below format.

 SELECT COUNT(*), column1, column2   FROM tablename  GROUP BY column1, column2  HAVING COUNT(*)>1;

we can found the duplicates depends on more then one fields also.For those cases you can use below format.

 SELECT COUNT(*), column1, column2 FROM tablename  GROUP BY column1, column2  HAVING COUNT(*)>1;

we can found the duplicates depends on more then one fields also.For those cases you can use below format.

SELECT COUNT(*), column1, column2   FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1;
Source Link
KESAVAN PURUSOTHAMAN
KESAVAN PURUSOTHAMAN
  • 453
  • 1
  • 5
  • 13

we can found the duplicates depends on more then one fields also.For those cases you can use below format.

 SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1;