SELECT id, name, count( * ) AS again
FROM tablename
GROUP BY name
HAVING again >1
ORDER BY name ASC
Kategoriler
SQL ile tekrar eden kayıtları bulmak

SELECT id, name, count( * ) AS again
FROM tablename
GROUP BY name
HAVING again >1
ORDER BY name ASC