Cacher is the code snippet organizer for pro developers

SELECT * FROM table_name
WHERE value IN (
  SELECT value
	FROM table_name
	GROUP BY value
	HAVING count(value) > 1
	)
ORDER BY value;