Vind dubbelle records

Voorbeeld voor vinden van dubbele email adressen:

SELECT email, 
 COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Of vind de e-mail adressen met 1 occurance:

SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )

{{opmerking.Naam}}:

{{opmerking.OpmerkingText}}

            

Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!