select substr(unitid,1, 1), sum(cnt) from 表名 group by substr(unitid,1, 1);
select substr(UNITID,1,1) 开头,sum(Cnt) 汇总 from table_name where 1=1 group by substr(UNITID,1,1) 应该是可行的,不行的话再联系我
SELECT SUBSTR(UNITID,1,1),SUM(Cnt) FROM T GROUP BY SUBSTR(UNITID,1,1);这样的需求太狠了。后续肯定会有很多问题出现。
<div> with t as( select '1' UNITID ,'10' Cnt from dual union all select '2' UNITID ,'20' Cnt from dual union all select '11' UNITID ,'15' Cnt from dual union all select '111' UNITID ,'30' Cnt from dual ) select substr(UNITID,1,1), sum(Cnt) from t group by substr(UNITID,1,1) </div>
from 表名
group by substr(unitid,1, 1);
substr(UNITID,1,1)
应该是可行的,不行的话再联系我
with t as(
select '1' UNITID ,'10' Cnt from dual
union all
select '2' UNITID ,'20' Cnt from dual
union all
select '11' UNITID ,'15' Cnt from dual
union all
select '111' UNITID ,'30' Cnt from dual
)
select substr(UNITID,1,1), sum(Cnt) from t
group by substr(UNITID,1,1)
</div>