select * from customers b where b.CUSTOMERID in (
select CUSTOMERID from ORDERS group by CUSTOMERID having count (*)>20
)order by b.CUSTOMERID desc
oracle 查询出重复的数据
最新推荐文章于 2023-01-20 09:21:54 发布
select * from customers b where b.CUSTOMERID in (
select CUSTOMERID from ORDERS group by CUSTOMERID having count (*)>20
)order by b.CUSTOMERID desc