Hi Kuya,

I got it...

select acct_no,name from TRANSACT where (acct_no,name) in
(select acct_no,name from(select distinct acct_no,name from TRANSACT)
group by acct_no,name having count(*)>1);

Are there other better ones pls...

Thanks