用子查询: select min(类型) as 类型,sum(数量) as 数量,sum(包数) as 包数 from (select StrLeft(编号,2) as 类型,数量,包数 from 表) group by 类型其中的StrLeft(Str,Num)函数视具体数据库而定,反正你能取得首两个字符即可。
如果是SelServer,有个更简单的做法: Select left(编号,2) as 类型,sum(数量) as 数量,sum(包数) as 包数 from 表 group by left(编号,2)以上Sql语句经过实验,完全可行。
统计po类型的:
select sum(数量),sum(包数) from 表 group by 类型 having 类型 like 'po%'
select min(类型) as 类型,sum(数量) as 数量,sum(包数) as 包数 from (select StrLeft(编号,2) as 类型,数量,包数 from 表) group by 类型其中的StrLeft(Str,Num)函数视具体数据库而定,反正你能取得首两个字符即可。
Select left(编号,2) as 类型,sum(数量) as 数量,sum(包数) as 包数 from 表 group by left(编号,2)以上Sql语句经过实验,完全可行。
拥护名/密码 见短信