Frage zu Count(*) SQL Statement

[codeslayer]

hi Samy,

GROUP BY ist dein Freund:

SELECT field, COUNT(*) as count FROM table
GROUP BY field
HAVING count > 1

achtung, ungetested.

Gruß,
Niklas