把分组统计后的结果集放到全部结果集里面查

select *
  from dba_objects d
 where exists (select 1
          from (
               
                select d.owner, count(*)
                  from dba_objects d
                 where d.owner in (‘TRADE_HNGJS‘, ‘TRADE_HXGJS‘)
                 group by d.owner) t
         where t.owner = d.owner)

本文出自 “青天飞云” 博客，转载请与作者联系！

把分组统计后的结果集放到全部结果集里面查

原文：http://liuhuanxin.blog.51cto.com/4789310/1731349