Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

jamesming
Plastyksouljah
fwd


Find Duplicate values in a table column


 / Published in: SQL
 

  1. -- An example of finding duplicate values in a table column
  2.  
  3. SELECT *
  4. FROM [dbo].[UserII]
  5. WHERE [passwd]
  6. IN (
  7. SELECT [passwd]
  8. FROM [dbo].[UserII]
  9. GROUP BY [passwd]
  10. HAVING COUNT(*) > 1
  11. )

Report this snippet  

You need to login to post a comment.