select 店铺,sum(金额),sum(数量) from tt where DATEDIFF(时间,now())<=3 group by 店铺
解决方案 »
- 新闻网站数据库设计问题
- MySQL server has gone away问题
- 创建约束后,插入数据失败?
- LIKE里面参数如何才能引用到表的字段啊
- mysql中innodb表设置的问题.
- sql2000中数据导入到mysql
- psql如何查二日期之前?
- 急!date型字段问题
- 请帮忙看一下SELECT语句哪里有问题
- 如何在c环境下实现批处理?
- mysqldump导入错误 ERROR 2002 (HY000): Can't connect to local MySQL server
- Encountered a duplicated sql alias [job_id] during auto-discovery of a native-sq
from 一个表
where 时间<curdate()-interval 3 day
group by date(时间),店铺代码
SELECT
CANGKU.CKDM AS CKDM,
CANGKU.CKMC AS CKMC,
SUM (VW_QTLSMX3.SL) AS SL,
SUM (VW_QTLSMX3.JE1) AS JE,
SUM (VW_QTLSMX3.CKJ * SL) AS CKJ
FROM
VW_QTLSMX3,
CANGKU
WHERE
VW_QTLSMX3.CKDM = CANGKU.CKDM
AND VW_QTLSMX3.CKDM IN (
SELECT
CKDM
FROM
CANGKU
WHERE
QYDM = '100'
AND QDDM = '000'
)
AND DateDiff(hh,RQ,getDate())<=120
AND VW_QTLSMX3.SPDM IN (
SELECT
SPDM
FROM
SHANGPIN
WHERE
BYZD4 IN ('000', '001')
)
GROUP BY
CANGKU.CKDM,
CANGKU.CKMC
现在结果是这样的但是我要的结果是 加上红框部分的算一条记录