select * from table t where t. businesscode in (select t1.businesscode from table t1 group by businesscode having count(*) >1 )
