s****e 发帖数: 1180 | 1 有如下data:
date sales
11/01/2012 110
12/01/2012 200
01/03/2013 120
01/04/2014 300
需要,从这组数据,得到如下report:
day
month mon tues wed thurs fri sat sun
jan sales sales sales ...
feb ...
march ...
... ...
有没有会的,能不能指导一下,多谢!:) | z*u 发帖数: 329 | | s****e 发帖数: 1180 | 3 就是要得出,每个月的星期一到星期天的每一天的,sales 的sum。
【在 z*u 的大作中提到】 : 没看懂
| l*********8 发帖数: 4642 | 4 MySQL:
select
monthname(date) Month,
sum(IF(dayofweek(date) = 2, sale, 0)) Mon,
sum(IF(dayofweek(date) = 3, sale, 0)) Tue,
sum(IF(dayofweek(date) = 4, sale, 0)) Wed,
sum(IF(dayofweek(date) = 5, sale, 0)) Thu,
sum(IF(dayofweek(date) = 6, sale, 0)) Fri,
sum(IF(dayofweek(date) = 7, sale, 0)) Sat,
sum(IF(dayofweek(date) = 1, sale, 0)) Sun
from sales_table
group by Month
order by month(date);
【在 s****e 的大作中提到】 : 有如下data: : date sales : 11/01/2012 110 : 12/01/2012 200 : 01/03/2013 120 : 01/04/2014 300 : 需要,从这组数据,得到如下report: : day : month mon tues wed thurs fri sat sun : jan sales sales sales ...
| s****e 发帖数: 1180 | 5 在自己的机器上试了一下。对的。多谢!:)
【在 l*********8 的大作中提到】 : MySQL: : select : monthname(date) Month, : sum(IF(dayofweek(date) = 2, sale, 0)) Mon, : sum(IF(dayofweek(date) = 3, sale, 0)) Tue, : sum(IF(dayofweek(date) = 4, sale, 0)) Wed, : sum(IF(dayofweek(date) = 5, sale, 0)) Thu, : sum(IF(dayofweek(date) = 6, sale, 0)) Fri, : sum(IF(dayofweek(date) = 7, sale, 0)) Sat, : sum(IF(dayofweek(date) = 1, sale, 0)) Sun
|
|