bradlilley
4/4/2013 - 11:49 PM

Find all duplicate rows by value.

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;