Mysql的总和
问题描述:
我需要现金以及各个公司的信用总和与对应的日期Mysql的总和
+-----------+------------+---------------+--------+----------
| ID | SaleDate | Cash | Credit |company |
+-----------+------------+---------------+--------+----------
| 1 | Nov-12-2016| 100 | 150|company 1|
| 2 | Nov-12-2016| 200 | 100|Company 1|
| 3 | Nov-13-2016| 150 | 200|Company 2|
| 4 | Nov-13-2016| 250 | 250|Company 2|
| 5 | Nov-14-2016| 80 | 50|Company 3|
| 6 | Nov-14-2016| 500 | 600|Company 3|
| | Nov-15-2016| 300 | 300|Company 4|
+-----------+------------+---------------+--------+---------+
所需的输出是
+------------+---------------+--------+----------
| SaleDate | Cash | Credit |company |
+------------+---------------+--------+----------
| Nov-12-2016| 300 | 250|company 1|
| Nov-13-2016| 400 | 450|Company 2|
| Nov-14-2016| 580 | 650|Company 3|
| Nov-15-2016| 300 | 300|Company 4|
+-----------+------------+---------------+------+
我不知道如何要做到这一点,请帮我找到一个解决方案在此先感谢...
答
select SaleDate,sum(Cash)Cash,sum(Credit)Credit,company
from tbl_name group by
SaleDate,company
+0
其工作完全非常感谢你.... –
答
尝试这样
SELECT SUM(cash) AS Total_cash,SUM(Credit) AS Total_credit,*
FROM `table_name`
GROUP BY SaleDate
这确实是一个基本问题。在同样的情况下,SO中有很多问题。在问这个重复的问题之前,请尝试适当的研究 – Viki888