SELECT
a.FSkuNumber FSkuNumber,
SUM(a.fqty) fqty,
e.finvqty finvqty,
e.finvqty-SUM(a.fqty) fnowlowqty,
MAX(e.finvqty-SUM(a.fqty)) maxqty,
e.Fcansellqty Fcansellqty
from sell_systradeitem a
LEFT JOIN sell_systrade b on a.fid=b.FID
LEFT JOIN pub_trade_taobaoitem c on a.foid=c.Foid
LEFT JOIN qtyinfo e on a.FSkuID=e.Fskuid and a.FStockID=e.Fstockid
我現在要求最大值請問應該如何寫
uj5u.com熱心網友回復：
把沒有聚合的列全部放到后面的group by中uj5u.com熱心網友回復：
MAX(e.finvqty-SUM(a.fqty)) maxqty,e.finvqty ，這列是一個非聚合列，他要與一個 SUM 函式做運算是不行的。
uj5u.com熱心網友回復：
SELECT
a.FSkuNumber FSkuNumber,
a.fqty fqty,
e.finvqty finvqty,
e.finvqty-a.fqty fnowlowqty,
MAX(e.finvqty-a.fqty) maxqty,
e.Fcansellqty Fcansellqty
from
SELECT(
s.FSkuNumber,
s.fid,
s.foid,
s.fskuid,
s.fstockid,
SUM(s.fqty) AS fqty
FROM
sell_systradeitem s
GROUP BY
s.FSkuNumber,
s.fid,
s.foid,
s.fskuid,
s.fstockid
) a
LEFT JOIN sell_systrade b on a.fid=b.FID
LEFT JOIN pub_trade_taobaoitem c on a.foid=c.Foid
LEFT JOIN qtyinfo e on a.FSkuID=e.Fskuid and a.FStockID=e.Fstockid
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/69660.html
標籤：基礎和管理