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

Duplikate finden

Language: Deutsch
Programming Language: SQL
Published by: Thomas
Last Update: 4/24/2006
Views: 2405

Description

Das folgende Statement liefert alle Duplikate in einer Tabelle und die Anzahl derer:

Code

1 SELECT Feld, COUNT(Feld) AS NumOccurrences 2 FROM Tabelle GROUP BY Feld 3 HAVING ( COUNT(Feld) > 1 )

No comments avaiable

Add a comment

Name *  

Email (won't be displayed) *    

Website  

Comment *  

Sicherheitscode Security Code *    

RSS