优化SQL语句：统计汇总数据

{/'title/':/'优化SQL语句：统计汇总数据/',/'description/':/'优化后的SQL语句，用于统计汇总数据，并按C_CITID进行分组。/',/'keywords/':/'SQL优化, 汇总统计, 分组, SQL语句/',/'content/':/'SELECT x.C_PRONAME AS NAT_C_PRONAME, x.C_PROID AS NAT_C_PROID, x.C_CITNAME AS NAT_C_CITNAME, x.C_CITID AS NAT_C_CITID, x.C_COUNAME AS NAT_C_COUNAME, x.C_COUID AS NAT_C_COUID, x.C_TOWNAME AS NAT_C_TOWNAME, x.C_TOWID AS NAT_C_TOWID, x.C_VILNAME AS NAT_C_VILNAME, x.C_VILID AS NAT_C_VILID, x.C_PLACENAME AS NAT_C_PLACENAME, x.R_UNIT_ID AS NAT_R_UNIT_ID, x.R_VILLAGEREPORT_ID AS NAT_R_VILLAGEREPORT_ID, x.C_WE001 AS NAT_C_WE001, x.C_NS002 AS NAT_C_NS002, //nSUM(x.C_AA001) AS NAT_C_AA001, SUM(x.C_AA002) AS NAT_C_AA002, SUM(x.C_AA003) AS NAT_C_AA003, SUM(x.C_BA001) AS NAT_C_BA001, SUM(x.C_BA002) AS NAT_C_BA002, SUM(x.C_BB001) AS NAT_C_BB001, SUM(x.C_BB002) AS NAT_C_BB002, SUM(x.C_BB003) AS NAT_C_BB003, SUM(x.C_BB004) AS NAT_C_BB004, SUM(x.C_BB006) AS NAT_C_BB006, SUM(x.C_BB008) AS NAT_C_BB008, SUM(x.C_BB010) AS NAT_C_BB010, SUM(x.C_DA001) AS NAT_C_DA001, SUM(x.C_DA002) AS NAT_C_DA002, SUM(x.C_DA003) AS NAT_C_DA003, SUM(x.C_DA004) AS NAT_C_DA004, SUM(x.C_DB001) AS NAT_C_DB001, SUM(x.C_DB002) AS NAT_C_DB002, SUM(x.C_DB003) AS NAT_C_DB003, SUM(x.C_EA001) AS NAT_C_EA001, SUM(x.C_EA002) AS NAT_C_EA002, SUM(x.C_EB004) AS NAT_C_EB004, SUM(x.C_EB002) AS NAT_C_EB002, SUM(x.C_FA001) AS NAT_C_FA001, SUM(x.C_FA004) AS NAT_C_FA004, SUM(x.C_FA005) AS NAT_C_FA005, SUM(x.C_FA006) AS NAT_C_FA006, SUM(x.C_FB001) AS NAT_C_FB001, x.C_WATERNAME AS NAT_C_WATERNAME, //nSUM(x.C_B1) AS NAT_C_B1, SUM(x.C_B2) AS NAT_C_B2, SUM(x.C_B3) AS NAT_C_B3, SUM(x.C_B4) AS NAT_C_B4, SUM(x.C_B5) AS NAT_C_B5, SUM(x.C_GA001) AS NAT_C_GA001, SUM(x.C_GA002) AS NAT_C_GA002, SUM(x.C_GC001) AS NAT_C_GC001, SUM(x.C_GD002) AS NAT_C_GD002, SUM(x.C_GB004) AS NAT_C_GB004, SUM(x.C_GB002) AS NAT_C_GB002, SUM(x.C_A1) AS NAT_C_A1, SUM(x.C_A2) AS NAT_C_A2, SUM(x.C_A3) AS NAT_C_A3, SUM(x.C_A4) AS NAT_C_A4, SUM(x.C_IA001) AS NAT_C_IA001, SUM(x.C_IA002) AS NAT_C_IA002, SUM(x.C_IA006) AS NAT_C_IA006, SUM(x.C_IA003) AS NAT_C_IA003, SUM(x.C_IA004) AS NAT_C_IA004, SUM(x.C_IA005) AS NAT_C_IA005, SUM(x.C_IB001) AS NAT_C_IB001, SUM(x.C_IB002) AS NAT_C_IB002, SUM(x.C_JA001) AS NAT_C_JA001, SUM(x.C_JA003) AS NAT_C_JA003, SUM(x.C_JA006) AS NAT_C_JA006, SUM(x.C_JA005) AS NAT_C_JA005, SUM(x.C_C8) AS NAT_C_C8, SUM(x.C_C10) AS NAT_C_C10, SUM(x.C_JA002) AS NAT_C_JA002, SUM(x.C_JA010) AS NAT_C_JA010, SUM(x.C_JB001) AS NAT_C_JB001, x.C_LOCATIONNAMES AS NAT_C_LOCATIONNAMES, SUM(x.C_KA001) AS NAT_C_KA001, SUM(x.C_KA002) AS NAT_C_KA002, SUM(x.C_A9) AS NAT_C_A9, SUM(x.C_A10) AS NAT_C_A10, SUM(x.C_A15) AS NAT_C_A15, SUM(x.C_A16) AS NAT_C_A16, SUM(x.C_A17) AS NAT_C_A17, SUM(x.C_A8) AS NAT_C_A8, SUM(x.C_BB005) AS NAT_C_BB005, SUM(x.C_BB007) AS NAT_C_BB007, SUM(x.C_BB009) AS NAT_C_BB009, SUM(x.C_FA002) AS NAT_C_FA002, SUM(x.C_B9) AS NAT_C_B9, x.C_OTHERONE_B9 AS NAT_C_OTHERONE_B9, SUM(x.C_B10) AS NAT_C_B10, x.C_OTHERONE_B10 AS NAT_C_OTHERONE_B10, SUM(x.C_A11) AS NAT_C_A11, SUM(x.C_A12) AS NAT_C_A12, SUM(x.C_A13) AS NAT_C_A13, SUM(x.C_A14) AS NAT_C_A14, SUM(x.C_A5) AS NAT_C_A5, SUM(x.C_A6) AS NAT_C_A6, SUM(x.C_A7) AS NAT_C_A7, SUM(x.C_A18) AS NAT_C_A18, SUM(x.C_A19) AS NAT_C_A19, SUM(x.C_A20) AS NAT_C_A20, SUM(x.C_A21) AS NAT_C_A21, SUM(x.C_A22) AS NAT_C_A22, SUM(x.C_A23) AS NAT_C_A23, SUM(x.C_A24) AS NAT_C_A24, SUM(x.C_A25) AS NAT_C_A25, SUM(x.C_A26) AS NAT_C_A26, SUM(x.C_A27) AS NAT_C_A27, SUM(x.C_A28) AS NAT_C_A28, SUM(x.C_A29) AS NAT_C_A29, SUM(x.C_A30) AS NAT_C_A30, SUM(x.C_A31) AS NAT_C_A31, SUM(x.C_A32) AS NAT_C_A32, SUM(x.C_A33) AS NAT_C_A33, SUM(x.C_A34) AS NAT_C_A34, SUM(x.C_A35) AS NAT_C_A35, SUM(x.C_A36) AS NAT_C_A36, SUM(x.C_A37) AS NAT_C_A37, SUM(x.C_A38) AS NAT_C_A38, SUM(x.C_A39) AS NAT_C_A39, SUM(x.C_A40) AS NAT_C_A40, SUM(x.C_A41) AS NAT_C_A41, SUM(x.C_A42) AS NAT_C_A42, SUM(x.C_A43) AS NAT_C_A43, SUM(x.C_A44) AS NAT_C_A44, SUM(x.C_A45) AS NAT_C_A45, SUM(x.C_A46) AS NAT_C_A46, SUM(x.C_A47) AS NAT_C_A47, SUM(x.C_A48) AS NAT_C_A48, SUM(x.C_A49) AS NAT_C_A49, SUM(x.C_A50) AS NAT_C_A50, SUM(x.C_A51) AS NAT_C_A51, SUM(x.C_A52) AS NAT_C_A52, SUM(x.C_A53) AS NAT_C_A53, SUM(x.C_A54) AS NAT_C_A54, SUM(x.C_A55) AS NAT_C_A55, SUM(x.C_A56) AS NAT_C_A56, SUM(x.C_A57) AS NAT_C_A57, SUM(x.C_A58) AS NAT_C_A58, SUM(x.C_A59) AS NAT_C_A59, SUM(x.C_A60) AS NAT_C_A60, SUM(x.C_A61) AS NAT_C_A61, SUM(x.C_A62) AS NAT_C_A62, SUM(x.C_A63) AS NAT_C_A63, SUM(x.C_A64) AS NAT_C_A64, SUM(x.C_A65) AS NAT_C_A65, SUM(x.C_A66) AS NAT_C_A66, SUM(x.C_A67) AS NAT_C_A67, SUM(x.C_A68) AS NAT_C_A68, SUM(x.C_A69) AS NAT_C_A69, SUM(x.C_A70) AS NAT_C_A70, SUM(x.C_A71) AS NAT_C_A71, SUM(x.C_A72) AS NAT_C_A72, SUM(x.C_A73) AS NAT_C_A73, SUM(x.C_A74) AS NAT_C_A74, SUM(x.C_A75) AS NAT_C_A75, SUM(x.C_A76) AS NAT_C_A76, SUM(x.C_A81) AS NAT_C_A81, SUM(x.C_A82) AS NAT_C_A82, SUM(x.C_A83) AS NAT_C_A83, SUM(x.C_A84) AS NAT_C_A84, SUM(x.C_A85) AS NAT_C_A85, SUM(x.C_A86) AS NAT_C_A86, SUM(x.C_A87) AS NAT_C_A87, SUM(x.C_A88) AS NAT_C_A88, SUM(x.C_A89) AS NAT_C_A89, SUM(x.C_A96) AS NAT_C_A96, SUM(x.C_A98) AS NAT_C_A98, SUM(x.C_A90) AS NAT_C_A90, SUM(x.C_A91) AS NAT_C_A91, SUM(x.C_A92) AS NAT_C_A92, SUM(x.C_A93) AS NAT_C_A93, SUM(x.C_A94) AS NAT_C_A94, SUM(x.C_A95) AS NAT_C_A95, SUM(x.C_A97) AS NAT_C_A97, SUM(x.C_A99) AS NAT_C_A99, COUNT(*) AS NAT_C_NATCOUNT,SUM(x.C_A100) AS NAT_C_A100,SUM(x.C_A101) AS NAT_C_A101,SUM(x.C_A102) AS NAT_C_A102,SUM(x.C_A103) AS NAT_C_A103,SUM(x.C_A104) AS NAT_C_A104,SUM(x.C_A105) AS NAT_C_A105,SUM(x.C_A106) AS NAT_C_A106, SUM(x.C_A107) AS NAT_C_A107, SUM(x.C_A108) AS NAT_C_A108, SUM(x.C_A109) AS NAT_C_A109, SUM(x.C_A110) AS NAT_C_A110, SUM(x.C_A111) AS NAT_C_A111, SUM(x.C_A112) AS NAT_C_A112//nFROM t_d_nvfillform x//nWHERE //n 1=1//n AND x.R_TASK_ID = 20//n AND C_DELETED = 0//n GROUP BY C_CITID/