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
|
|
