oracle 数据库删除重复数,保留rowid最小的
select * from lims_sample_programs where (criterionid) in
(select criterionid from lims_sample_programs group by criterionid having count(criterionid) >1)
and rowid not in (select min(rowid) ...
原创
2019-11-12 09:50:10 ·
408 阅读 ·
0 评论