我有一個名為總銷售額的表。在此表中有銷售資料，如發票日期和銷售發票的分公司名稱和數量。
我正在嘗試進行查詢以獲取每個日期的每個分支的總銷售額，我的代碼在下面，但是當我執行代碼時，查詢回傳錯誤，我無法確定每一列的條件。
我的代碼：
SELECT invoice_date,
COUNT(quantity) AS malqaStore,
COUNT(quantity) AS tahliaStore
FROM total_sales
WHERE branche_name = 'branch1'
AND branche_name = 'branch2'
GROUP BY invoice_date;
uj5u.com熱心網友回復：
根據您的描述，您想要的應該是
SELECT invoice_date,
SUM(case when branche_name = 'branch1' then quantity end) AS malqaStore,
SUM(case when branche_name = 'branch2' then quantity end) AS tahliaStore
FROM total_sales
WHERE branche_name in ( 'branch1' , 'branch2' )
GROUP BY invoice_date;
您可以使用branche_name in ( 'branch1' , 'branch2' )或WHERE branche_name = 'branch1' OR branche_name = 'branch2'過濾您需要的 2 個分支。
至于malqaStoreand tahliaStore，我猜你想要每個 branche_name 的數量的條件總和
uj5u.com熱心網友回復：
您需要在您的選擇中添加分支名稱并分組，以按每個分支名稱匯總資料。
嘗試類似..
SELECT invoice_date,
branche_name,
COUNT(quantity) AS malqaStore,
COUNT(quantity) AS tahliaStore
FROM total_sales
WHERE branche_name = 'branch1'
OR branche_name = 'branch2' --<-- also you need an OR here not AND
GROUP BY invoice_date , branche_name;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/477197.html
上一篇：如何在回圈中重復執行存盤程序？
下一篇：SQLCE回傳時間范圍的總和值