多条select语句的合并

1 select 
2   (select count(*) from DW_MARK_FXJS.F_GS_YCXJJDCSY@new_zgxt  where ssq>='201401' and ssq<'201701') ,
3   (select count(distinct swglm) from DW_MARK_FXJS.F_GS_YCXJJDCSY@new_zgxt  where ssq>='201401' and ssq<'201701') ,
4   (select max(ssq) from DW_MARK_FXJS.F_GS_YCXJJDCSY@new_zgxt )
5 from dual

这样就不用傻傻的执行三次sql了

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/dayuruozhi/p/6605816.html