(1)创建一张jiaban表
create table jiaban(
num int,
dt date
)engine myisam charset utf8;
insert into jiaban
values
(5, ‘2012-09-01’),
(6, ‘2012-09-02’),
(7, ‘2012-09-03’),
(8, ‘2012-09-04’),
(9, ‘2012-09-05’),
(10, ‘2012-09-06’),
(11, ‘2012-09-07’),
(12, ‘2012-09-08’),
(13, ‘2012-09-09’),
(14, ‘2012-09-10’),
(15, ‘2012-09-11’),
(16 , ‘2012-09-12’);
(2)思路:解决问题的关键在于我们如何进行group,这里的思路是将dt转为一年中的周数。
然后根据周进行分组,然后sum(num)即每周的加班时间。