如果是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 ,qcmc,qctz
就有重复的记录,到底怎么办啊
解决方案 »
- 高分,怎么在sql2008理设置登录账号
- 硬盘数据恢复的数据库文件,能成功附加,但是checkdb报错
- 请问是否有法对视图里的某字段进行判断操作呢?
- 发布软件时候,给用户一个脚本.SQL安装
- 使用 sql server 2000 存储过程 sp_xml_preparedocument 解析XML文件,当XML超过varchar(8000) 怎么办???
- ACCESS中的OLE字段类型是SQL中的什么字段类型?
- 求一动态SQL
- SQL 語句
- 大家快来看一下是不是真的?》MSSQL真的那么差劲吗?
- 怎么样对数据库在每日固定的时间进行数据处理?
- 这个SQL怎么写???
- 捕捉存储过程中错误的问题。。。很困惑。代码如下
from 表
where riqi between '2004-01-02' and '2004-01-04'
group by qcbm,qcmc,qctz...
from 表 a join(
select id=min(id),jcsl=sum(jcsl)
from 表
group by qcbm
)b on a.id=b.id
from 表
where riqi between '2004-01-02' and '2004-01-04'
group by qcbm,qcmc
from 表 a join(
select id=min(id),jcsl=sum(cast(jcsl as int))
from 表
where riqi between '2004-01-02' and '2004-01-04'
group by qcbm
)b on a.id=b.id