SQL Duplicate Row search

SELECT * FROM
RSS_USERS A
WHERE ( SELECT count(*) FROM
        RSS_USERS A1
        WHERE  A1.USERNAME = A.USERNAME
      ) > 1
ORDER BY A.USERNAME