You're here: Snippet Directory » Databases (26)
Language:

Find Duplicates in a field

Language: English
Programming Language: SQL
Published by: pjjt [not registered]
Last Update: 5/15/2006
Views: 1146


Description

Returns duplicates for a field.

Code

1 SELECT USERNAME FROM USERINFO GROUP BY USERNAME HAVING count(*) > 1

No comments avaiable

Add a comment

Name *  

Email (won't be displayed) *    

Website  

Comment *  

Sicherheitscode Security Code *    

RSS