select 店铺,sum(金额),sum(数量) from tt where DATEDIFF(时间,now())<=3 group by 店铺
解决方案 »
- mysql数据备份,然后再用
- 分布式数据库数据如何同步
- mysql union 与union all 使用
- 求SQL~~~~~~~~~
- mysql 问题,特急!!!!
- Mysql 数据存储问题
- 关于MYsql数据库中加密的问题,高手请进
- 在linux下如何用C语言对MYSQL数据进行删除和修改?
- 我从文本文件导入数据到MYSQL表,为什么记录的中文的内容都变成了####,而英文和数字正常。
- MySQL问题
- 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
现在结果是这样的但是我要的结果是 加上红框部分的算一条记录