sql查询,select from 后面只能是表吗? 不是。也可以是select的结果集合
select * from (select t.code as code,t.name as name,t1.biz_desc as biz_desc,t1.biz_type as biz_type
from org_port tleft join biz_dict t1
on t.code=t1.biz_value
) t2
where t2.biz_type = 'port'
明白了这个之后,所有统计查询,只在oracle客户端用sql语句去查询就足够了,根本不用去写程序做查询统计。