我希望避免重复使用子查询。(BuyingQty) elseSUM(buyingQty) - SUM(sellingQty) end as BalQty,SUM(ASP) as ASP,
(SUM(sellingQty) is null) then SUM(BuyingQty) else (SUM(buyingQty) - SUM(selling
然而,我们有多个区域的WC.Type可以是1,2,3,4。我需要把每一种类型的发生数到COUNT(WC.ID) AS "Region_1",COUNT(WC.ID) AS "Region_2" .取决于WC.Type。有办法在一个查询中解决这个问题吗?我正在查看MySQL IF,但不知道如何将它集成到count函数中。我需要它在一行中(这里显示的查询减少了,这是一个更大的查询)
SELECT COUNT(WC.ID) AS "Region_1" , COUNT(W
$comments = dbgetvar("SELECT SUM(CASE WHEN c.approve = '1' AND c.spam = '0' THEN 1ELSE0 END) AS approved,
SUM(CASE WHEN c.approve = '0' AND c.spam = '0
,SUM(Point) AS MEDAL,SUM(CASE WHEN Point = 7 THEN 1ELSE0 END) AS GoldCount,SUM(CASE WHEN Point = 5THEN 1ELSE0 END) AS SilverCount,SUM(CASE WHEN Point = 4 THEN 1ELSE0 END) AS Bro