SELECT field, COUNT(*)
FROM table
GROUP BY field
ORDER BY field
HAVING COUNT(*) > 1;