SELECT * FROM T
WHERE A IN (
SELECT A FROM T
GROUP BY A HAVING COUNT(A)>1)