MySQL SUM与分组数据
问题描述：
How to get data Price with grouped date ?
SELECT store.date, store.pic, owner.name,
SUM (CASE WHEN [>>GROUPED store.date<<] THEN store.price) AS total_price
FROM store
JOIN owner
ON store.pic = owner.name GROUP BY store.date
and i want to display like this :
+-------------+------+------------+
| date | name | price |
+-------------+------+------------+
| 2016-09-30 | John | 100000.00 |
| 2016-09-29 | Rey | 125000.00 |
+-------------+------+------------+
如何获取数据具有分组日期的价格？ p>
SELECT store.date，store.pic，owner.name，
SUM（CASE WHEN [＆gt;＆gt; GROUPED store.date＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆lt;＆n; .name GROUP BY store.date
code> pre>
我希望显示如下： p>
+ --- ---------- + ------ + ------------ + \ N | 日期| 名字| 价格|
+ ------------- + ------ + ------------ + \ N | 2016-09-30 | 约翰| 100000.00 |
| 2016-09-29 | 雷伊| 125000.00 |
+ ------------- + ------ + ------------ +
code> pre>
DIV>
答
Try this will may help you,
SELECT store.date, store.pic, owner.name,SUM(store.price) AS total_price
FROM store
JOIN OWNER ON store.pic = owner.name
GROUP BY store.date
i can't understand why you used case statement in your query