query to check the duplicates

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  February 17, 2020 at 8:49 pm

  #3726571

  i have a table, where a column ABC holds value 123 , based on this column ABC , i want to find how many id's exists. this is to see how many duplicates exists for each ABC column how many id's exits.

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  February 17, 2020 at 9:05 pm

  #3726577

  The easiest way to see how many duplicates exist for each, is to just use GROUP BY and HAVING clauses.  What have you tried?

   

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 17, 2020 at 9:05 pm

  #3726578

  SELECT ABC, COUNT(ABC) FROM dbo.YourTableNameHere GROUP BY ABC;