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

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)