根据条件得到 该月的的总和和月中每日的总和
例如:
id insert_time count1 count2 username
1 2008-12-01 2 3 a
2 2008-12-02 8 1 a
3 2008-12-03 2 1 a
4 2008-12-01 2 1 b
5 2008-12-01 2 1 c
6 2008-12-02 2 1 b
7 2008-12-03 2 1 c
得到如下结果:
username insert_time count1 count2
a 2008-12-01 2 3
b 2008-12-01 2 1
c 2008-12-01 2 1
日统计: 2008-12-01 6 5
a 2008-12-02 8 1
b 2008-12-02 2 1
日统计 2008-12-02 10 2
a 2008-12-03 2 1
c 2008-12-03 2 1
日统计 2008-12-03 4 2
总月踪迹:2008-12 20 9
例如:
id insert_time count1 count2 username
1 2008-12-01 2 3 a
2 2008-12-02 8 1 a
3 2008-12-03 2 1 a
4 2008-12-01 2 1 b
5 2008-12-01 2 1 c
6 2008-12-02 2 1 b
7 2008-12-03 2 1 c
得到如下结果:
username insert_time count1 count2
a 2008-12-01 2 3
b 2008-12-01 2 1
c 2008-12-01 2 1
日统计: 2008-12-01 6 5
a 2008-12-02 8 1
b 2008-12-02 2 1
日统计 2008-12-02 10 2
a 2008-12-03 2 1
c 2008-12-03 2 1
日统计 2008-12-03 4 2
总月踪迹:2008-12 20 9
--TRY IT
select decode(grouping(insert_time),1,'总月总计',insert_time),
decode(grouping(username),1,'月总计',username),sum(count1),sum(count2)
from yourtable
group by rollup(insert_time,username)