oracle 查询表中重复数据

select * from tablename where id in (
select id from tablename 
group by id 
having count(id) > 1
)

posted @ 2018-11-20 08:59  这座城市那么空  阅读(1614)  评论(0)  编辑  收藏  举报