EizoPeter
- EizoPeter 回答了问题 MySQL 查询优化问题
最后解决的方案 - EizoPeter 2019-05-21 已签到连续签到2天,获得了10个金钱
in 改为join模式
@花椒
SELECT sum(gross_margin) ASgross_sum
FROMyn_goods_analyze_shop_by_day
join (SELECTspid
FROMyn_goods_analyze_shop_by_day
WHEREcreate_date
BETWEEN '2019-05-13' AND '2019-05-19' GROUP BYspid
HAVING round(sum(saleroom)*0.88-sum(goods_cost)-6,1) < 0) AS u WHERE (create_date
BETWEEN '2019-05-13' AND '2019-05-19')
这样写得到的结果不对 应该怎么写大佬 求指导 QAQin 改为join模式
SELECT sum(gross_margin) AS
gross_sum
FROMyn_goods_analyze_shop_by_day
WHERE (create_date
BETWEEN '2019-05-13' AND '2019-05-19') AND (spid join (SELECTspid
FROMyn_goods_analyze_shop_by_day
WHEREcreate_date
BETWEEN '2019-05-13' AND '2019-05-19' GROUP BYspid
HAVING round(sum(saleroom)*0.88-sum(goods_cost)-6,1) < 0))
改成这样吗 ? 这样会报语法错误- EizoPeter 提出了问题MySQL 查询优化问题
- EizoPeter 发表了说说谎言的代价是什么?并非我们会把谎言误认为真相,真正危险的是 我们听多了谎言会再无法分辨出真相,到时我们要怎么办,只能抛弃追寻真相的希望 而满足于编造的故事
- EizoPeter 2019-05-20 已签到连续签到1天,获得了5个金钱
- EizoPeter 2019-05-16 已签到连续签到13天,获得了20个金钱