?? 一個簡單的統計sql.txt
字號:
ddd= " select zch_"+nnyy+".zcbb,zch_"+nnyy+".zcrq,zch_"+nnyy+".autodh, ~r~n"&
+" lx01=sum(case zch_"+nnyy+".zclx when 'LX01' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx02=sum(case zch_"+nnyy+".zclx when 'LX02' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx03=sum(case zch_"+nnyy+".zclx when 'LX03' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx04=sum(case zch_"+nnyy+".zclx when 'LX04' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx05=sum(case zch_"+nnyy+".zclx when 'LX05' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx06=sum(case zch_"+nnyy+".zclx when 'LX06' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" lx07=sum(case zch_"+nnyy+".zclx when 'LX07' then round(zch_"+nnyy+".zcje,2) else 0 end), ~r~n"&
+" zcrs=max(zch_"+nnyy+".zcrs) ~r~n"&
+" from zch_"+nnyy+" ~r~n"&
+" group by zch_"+nnyy+".zcbb,zch_"+nnyy+".zcrq,zch_"+nnyy+".autodh "
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -