select year(time) 年,
month(time) 月,
day(time) 日,
sum(num)
from table
group by year(time),
month(time),
day(time)
或者
select convert(char(8),time,112) dt,
sum(num)
from table
group by convert(char(8),time,112)
select year(time) 年,
month(time) 月,
day(time) 日,
sum(num)
from table
group by year(time),
month(time),
day(time)
或者
select convert(char(8),time,112) dt,
sum(num)
from table
group by convert(char(8),time,112)