mysql - 按星期几分组销售

Question

我有一张看起来像这样的 table

sell_price double        buy_price double      time int(11)
31.5                     20.5                  1353755931 (2012-11-27)
20                       10.5                  1353755235 (2012-11-27)
40                       30                    1353752531 (2012-11-26)
50                       25                    1353751237 (2012-11-26)
40                       10                    1353745609 (2012-11-25)           

我正在尝试对所有值进行分组以获得一周中每一天的销售额，所需的表格应如下所示:

sell_price double        buy_price double      time int(11)
51.5                     30.5                  1353755931 (2012-11-27)
90                       55                    1353755931 (2012-11-26)
40                       10                    1353755931 (2012-11-25) 

我尝试了以下查询，但我似乎对分组有问题

SELECT sell_price, buy_price, time 
FROM sales 
GROUP BY DAY(time) 
ORDER BY time DESC

上面的查询只返回 1 行

31.5       20.5      1353755931 

实现这一目标的正确方法是什么？

Answer 1

SELECT DATE(FROM_UNIXTIME(time)) time,
       SUM(sell_price),
       SUM(buy_price)
FROM tableName
GROUP BY DATE(FROM_UNIXTIME(time))