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了
原文：http://www.cnblogs.com/dayuruozhi/p/6605816.html