Find all duplicate rows by value.
SELECT * FROM table_name WHERE value IN ( SELECT value FROM table_name GROUP BY value HAVING count(value) > 1 ) ORDER BY value;