引用 2 楼 herowang 的回复:
SQL code
select b,sum(a)
from tb
where c between convert(char(10),getdate,120)+"0:0:0" and convert(char(10),getdate,120)+"23:59:59"
group by b
[Quote=引用 2 楼 herowang 的回复:]
SQL code
select b,sum(a)
from tb
where c between convert(char(10),getdate,120)+"0:0:0" and convert(char(10),getdate,120)+"23:59:59"
group by b