一个简单的统计sql.txt

来自「PB常用技巧 PB常用技巧 PB常用技巧」· 文本 代码 · 共 12 行

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 "