sql日期分组的
Ic20120410007080NULLadmin 0无2012-04-07 00:00:00.000
Ic20120410008030NULL02012-04-10 15:44:09.093
Ic201204100090300NULLNULL0NULL2012-04-10 00:00:00.000
Ic20120410010030NULL02012-04-10 15:56:08.720
Ic20120410011050NULL02012-04-10 15:57:34.000


如图上表。
想根据天来统计出收入。
请教各位大神怎么写。谢谢了

[解决办法]

SQL code

select sum(收入) ,convert(varchar(10),date,120) from tb group by convert(varchar(10),date,120)
[解决办法]
SQL code
select convert(varchar(10),[时间字段]) as [时间],sum([收入])from [表名]group by convert(varchar(10),[时间字段])