advanced code snippet search

Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

jamesming
Plastyksouljah
fwd
johnw


Find Duplicate values in a table column

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.