php - SQL PHP 检索特定商店的总金额

Question

是否有一个查询可以检索每个 StoreName 的 TotalMoney、TotalPaidMoney、TotalReturnMoney。

喜欢:

StoreName|   TotalPaid      |     ToatalReturn       |  TotalMoney    
Pizza    | sum of PaidMoney |  sum of ReturnMoney    | sum of TotalMoney
         |                  

从此表

Date | StoreName|PaidMoney| ReturnMoney| TotalMoney
*********
2014 | Pizaa    | 33$     | 12$        | 120$
2014   Main       12$       23$          123$
2014 | Pizaa    | 33$     | 12$        | 120$
2014 | Main     | 33$     | 12$        | 120$

我有表:存储表

Answer 1

您可以轻松使用 GROUP BY 语句，如下所示:

SELECT StoreName, SUM(PaidMoney) as TotalPaid, SUM(ReturnMoney) as TotalReturn, SUM(TotalMoney) as TotalMoney FROM store_table GROUP BY StoreName