如何查询Oracle数据库中，一列数据相同的记录

select * from table t where t. businesscode in (
select t1.businesscode from table t1 group by businesscode having count(*) >1
)本回答被提问者和网友采纳