Is there a reason that you don't do this?

Code:

SELECT acct_no, name 
  FROM TRANSACT 
 GROUP BY acct_no, name 
HAVING COUNT(*)>1;
You don't need the distinct or the subquery.