Coding for "Not Distinct"

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  February 21, 2002 at 2:19 pm

  #77790

  I would like to run a simple query to identify duplicate records in a table, in other words, something like a NOT DISTINCT keyword would be perfect. Any ideas ?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 21, 2002 at 2:29 pm

  #424280

  If there is a main field you would want to know this on the something like this

  SELECT fldIwannaC

  FROM myTbl

  GROUP BY fldIwannaC

  HAVING COUNT(fldIwannaC) > 1

  If you want to see the entire row then there are a few ways include listing all the rows in the group by clause in the above or

  SELECT *

  FROM myTbl

  WHERE fldIwannaC IN (

  SELECT fldIwannaC

  FROM myTbl

  GROUP BY fldIwannaC

  HAVING COUNT(fldIwannaC) > 1

  )

• homebrew01

  SSC Guru

  Points: 55549

  More actions

  February 22, 2002 at 1:02 pm

  #424346

  Thanks for the help !

  If there is a main field you would want to know this on the something like this

  SELECT fldIwannaC

  FROM myTbl

  GROUP BY fldIwannaC

  HAVING COUNT(fldIwannaC) > 1

  If you want to see the entire row then there are a few ways include listing all the rows in the group by clause in the above or

  SELECT *

  FROM myTbl

  WHERE fldIwannaC IN (

  SELECT fldIwannaC

  FROM myTbl

  GROUP BY fldIwannaC

  HAVING COUNT(fldIwannaC) > 1

  )

  [/quote]