求SQL语句
仓库管理软件版1楼: 按一字段的前5位,进行分类汇总
如 AA BB
1330101 10
1330102 20
1350101 30
13701 20
结果:
13301 30
13501 30
13701 20
如 AA BB
1330101 10
1330102 20
1350101 30
13701 20
结果:
13301 30
13501 30
13701 20
2楼: Select substring(AA,1,5) as AA,sum(BB) as BB from tablename
group by substring(AA,1,5) 如进销存软件破解版
3楼: select substring(AA, 1,5) AA , sum(BB) from AGroup group by substring(AA, 1,5)
4楼: select substring(AA,1,5) AA,sum(BB) BB的和 from 表名 group by substring(AA,1,5)
5楼: 我试一下,我的数据库是:Access行吗?
6楼: ACCESS 中应该用 Mid函数:
Select Mid(AA,1,5) as AA,sum(BB) as BB from tablename
group by substring(AA,1,5)
仓库管理软件版7楼: Select Mid(AA,1,5) as AA,sum(BB) as BB from tablename
group by Mid(AA,1,5)
8楼: 来晚了,楼上的都对呀。
9楼: select DISTINCT mid(AA,1,5) ,sum(BB) From 表名 group by distinct mid(AA,1,5)
10楼: 又學到一些東東了,謝謝所有樓上的同仁了...
11楼: select left(AA,5),sum(BB) from tablename group by left(AA,5)
12楼: 如加上排序功能该如何写, 如手机进销存管理系统
13楼: 加上Order by mid(AA,1,5)
仓库管理软件版14楼: 多人接受答案了。