–查询重复数据
select *
from app_jf_value t1
where (t1.jfindcode, t1.areacode, t1.kpitype, t1.created_at) in
(select jfindcode, areacode, kpitype, created_at
from app_jf_value
group by jfindcode, areacode, kpitype, created_at
having count(*) > 1);
Oracle 多个字段重复查询
最新推荐文章于 2025-05-28 13:36:11 发布