Ic20120410007 0 80 NULL admin 0 无 2012-04-07 00:00:00.000
Ic20120410008 0 30 NULL 0 2012-04-10 15:44:09.093
Ic20120410009 0 300 NULL NULL 0 NULL 2012-04-10 00:00:00.000
Ic20120410010 0 30 NULL 0 2012-04-10 15:56:08.720
Ic20120410011 0 50 NULL 0 2012-04-10 15:57:34.000
如图上表。
想根据天来统计出收入。
请教各位大神怎么写。谢谢了
Ic20120410008 0 30 NULL 0 2012-04-10 15:44:09.093
Ic20120410009 0 300 NULL NULL 0 NULL 2012-04-10 00:00:00.000
Ic20120410010 0 30 NULL 0 2012-04-10 15:56:08.720
Ic20120410011 0 50 NULL 0 2012-04-10 15:57:34.000
如图上表。
想根据天来统计出收入。
请教各位大神怎么写。谢谢了
select sum(收入) ,convert(varchar(10),date,120) from tb group by convert(varchar(10),date,120)
select
convert(varchar(10),[时间字段]) as [时间],
sum([收入])
from [表名]
group by
convert(varchar(10),[时间字段])
CREATE TABLE TEST5
(
Col1 VARCHAR(100),
Col2 INT,
Col3 INT,
Col4 VARCHAR(200),
Col5 VARCHAR(100),
Col6 INT,
Col7 VARCHAR(100),
Col8 DATETIME
)
GOINSERT INTO TEST5
SELECT 'Ic20120410007', 0, 80, NULL, 'admin', 0, '无', '2012-04-07 00:00:00.000' UNION
SELECT 'Ic20120410007', 0, 30, NULL, '', 0, '', '2012-04-10 15:44:09.093' UNION
SELECT 'Ic20120410007', 0, 300, NULL, NULL, 0, NULL, '2012-04-10 00:00:00.000' UNION
SELECT 'Ic20120410007', 0, 30, NULL, '', 0, '', '2012-04-10 15:56:08.720' UNION
SELECT 'Ic20120410007', 0, 805, NULL, '', 0, '', '2012-04-10 15:57:34.000'
SELECT CONVERT(VARCHAR(100),Col8,23),SUM(Col2),SUM(Col3),SUM(Col6)
FROM TEST5
GROUP BY CONVERT(VARCHAR(100),Col8,23)(No column name) (No column name) (No column name) (No column name)
2012-04-07 0 80 0
2012-04-10 0 1165 0