56,687
社区成员
发帖
与我相关
我的任务
分享求：取出记录的总和要符合某个条件
用户，数量，日期
name,num,date
a,1,2012-02-01
a,1,2012-03-05
b,10,2012-02-03
a,3,2012-02-09
c,2,2012-04-05
----------------------
搜索条件是：取出: 2012-02月的用户，总数量要>=2
结果：
a,4,2012-02
b,10,2012-02
name,num,date
a,1,2012-02-01
a,1,2012-03-05
b,10,2012-02-03
a,3,2012-02-09
c,2,2012-04-05
----------------------
搜索条件是：取出: 2012-02月的用户，总数量要>=2
结果：
a,4,2012-02
b,10,2012-02
...全文
请发表友善的回复…
发表回复
rucypli 2012-04-08
- 打赏
- 举报
select name,sum(num),'2012-02'
from table1
where date >'2012-02-01' and date<'2012-03-01'
group by name
having sum(num)>=2
from table1
where date >'2012-02-01' and date<'2012-03-01'
group by name
having sum(num)>=2
ACMAIN_CHM 2012-04-06
- 打赏
- 举报
select name,sum(num),format(date,'%Y-%m')
from table1
where date between '2012-02-01' and '2012-02-29'
group by name
having sum(num)>=2
