SELECT 寻呼区 = CASE WHEN node_addr IN ('1.38.59@10.107.201.59 ') THEN '1-10' WHEN node_addr IN ('1.38.67@10.107.201.67 ') THEN '1-11' WHEN node_addr IN ('1.38.68@10.107.201.68 ', '1.38.69@10.107.201.69 ') THEN '1-12' WHEN node_addr IN ('1.38.60@10.107.201.60 ', '1.38.61@10.107.201.61 ') THEN '1-2' WHEN node_addr IN ('1.38.24@10.107.201.24 ', '1.38.70@10.107.201.70 ') THEN '1-7' WHEN node_addr IN ('2.38.70@10.107.202.70 ', '2.38.72@10.107.202.72 ') THEN '2-11' WHEN node_addr IN ('4.38.75@10.107.204.75 ', '4.38.76@10.107.204.76 ') THEN '4-3' WHEN node_addr IN ('3.38.107@10.107.203.107 ', '3.38.105@10.107.203.105 ', '3.38.106@10.107.203.106 ', '3.38.102@10.107.203.102 ', '3.38.103@10.107.203.103 ', '3.38.104@10.107.203.104 ') THEN '4-9' ELSE '' END, SUM(ST22 / 3600) AS 占用话务量总和, SUM(ST5) AS 线路断开时长总和 FROM CSC_TRAFFIC_DAY_8_7_2004 GROUP BY node_addr
这里能不能group by 寻呼区?
我试了,不能,为什么?
我想根据"寻呼区",有什么别的办法啊?
