select qcbm,jcsl=sum(cast(jcsl as int)) from 表 where riqi between '2004-01-01' and '2004-01-03' group by qcbm
如果有这个字段qcmc(名称),qctz(特征)要显示。改怎么加啊。下面的不行啊 select qcbm,jcsl=sum(cast(jcsl as int)),qcmc,qctz from 表 where riqi between '2004-01-01' and '2004-01-03' group by qcbm
如果是select qcbm,jcsl=sum(cast(jcsl as int)),qcmc,qctz from 表 where riqi between '2004-01-01' and '2004-01-03' group by qcbm ,qcmc,qctz 就有重复的记录,到底怎么办啊
from 表
where riqi between '2004-01-01' and '2004-01-03'
group by qcbm
select qcbm,jcsl=sum(cast(jcsl as int)),qcmc,qctz
from 表
where riqi between '2004-01-01' and '2004-01-03'
group by qcbm
from 表
where riqi between '2004-01-01' and '2004-01-03'
group by qcbm ,qcmc,qctz
就有重复的记录,到底怎么办啊