select 地市,
sum(G/T室分站比)
from (
SELECT CM_A_GTWL_GRID_GC_M.CITY_DESC "市县",
CM_A_GTWL_GRID_GC_M.REGION_DESC "地市",
ROUND((SUM( UC_INDOORRNC_CNT/decode(CELL_INDOORBSC_CNT,0,1,CELL_INDOORBSC_CNT))),2) "G/T室分站比"
FROM CM_A_GTWL_GRID_GC_M
WHERE CM_A_GTWL_GRID_GC_M.MONTH_ID = 201301
GROUP BY CM_A_GTWL_GRID_GC_M.CITY_DESC, CM_A_GTWL_GRID_GC_M.REGION_DESC
) group by 地市子查询别名有特殊字符,,请问上面红色的地方应该怎么改啊?
sum(G/T室分站比)
from (
SELECT CM_A_GTWL_GRID_GC_M.CITY_DESC "市县",
CM_A_GTWL_GRID_GC_M.REGION_DESC "地市",
ROUND((SUM( UC_INDOORRNC_CNT/decode(CELL_INDOORBSC_CNT,0,1,CELL_INDOORBSC_CNT))),2) "G/T室分站比"
FROM CM_A_GTWL_GRID_GC_M
WHERE CM_A_GTWL_GRID_GC_M.MONTH_ID = 201301
GROUP BY CM_A_GTWL_GRID_GC_M.CITY_DESC, CM_A_GTWL_GRID_GC_M.REGION_DESC
) group by 地市子查询别名有特殊字符,,请问上面红色的地方应该怎么改啊?
一 别名起个简单点的名字
二 sum(G/T室分站比) 修改为sum("G/T室分站比")
sum(G/T室分站比)
...一个地区比率是30%,别一个地区是80%,那求和该是多少比率?