easy!!
select field1,field2,field3
from table
group by bm
这样就能按部门分组了,
你在 SQL Explorer 里调试一下,可能 group by 后面还要加上选择的字段field1~field3
select field1,field2,field3
from table
group by bm
这样就能按部门分组了,
你在 SQL Explorer 里调试一下,可能 group by 后面还要加上选择的字段field1~field3
你的情况这样能实现:
select info.peij_no as 配件编码,
info.peij_th as 配件图号,
info.peij_mc as 配件名称,
info.peij_cx as 车型,
info.peij_jk as 进口,
info.peij_dw as 单位,
f2.peij_kc as 数量,
f2.jiag_jp as 单价,
f2.peij_je as 金额
from kucshp_info info,
(select peij_no, peij_je , peij_kc , case peij_kc when 0 then 0 else peij_je / peij_kc end jiag_jp from
(select peij_no,
sum(isnull(f.peij_kc,0)) as peij_kc,
sum(isnull(f.peij_je,0)) as peij_je
from kucshp_fl f group by peij_no ) f1 ) f2
where info.peij_no = f2.peij_no
真正的SQL 就是这么灵活。
Raptor(猛禽) 我要一次生成好几个部门的数据,你的方法行吗?
xiaojiachong(小甲虫) 你的方法能说清楚点吗?
有源码最好
Select BM,gwgz,glbt,yfbg,jbf,jj,yfxj,fzf,sdf,dhf,ghf,tcjj,sds,qtyk,ykxj,sfje from temp group by bm;
提示我错误如下:
General SQL error.
[Microsoft][ODBC Microsoft Access Driver] 试图执行的查询中不包含作为合计函数一部分的特定表达式 'gwgz' 。
我去掉‘GWGZ’后又出现'Glbt'为什么?神啊救救我吧!
select riqi,bm,sum(gwgz) as Gwhj,sum(glbt) as glhj,Sum(yfbg) as yfbghj,Sum(jbf) as jbfhj,Sum(jj) as jjhj,Sum(Yfxj) as yfhj,Sum(Fzf) as fzhj,Sum(sdf) as sdhj,Sum(Dhf) AS dhfhj,Sum(Ghf) as ghfhj,Sum(tcjj) as tchj,Sum(sds) as sdshj,Sum(Qtyk) as qtykhj, Sum(ykxj) as ykhj,Sum(sfje) as sfhj From Temp where Riqi='''+Edit1.Text+''' 是不是我这里错了?
Group by Bm