求每一天 某一列数据之和 请各位帮帮忙指点一下

[我还在下面游泳呢]

第一列 名 count double类型 第二列 名 sDate detetime 类型，这里精确到了秒，我要查询7天之类所有数据，但是每一天数据要求求和， SQL 或者Linq 都可以

[吉普赛的歌]

DECLARE @t TABLE(cnt DECIMAL(10,2),sDate DATETIME)
INSERT INTO @t
	SELECT 0.01,'2017-03-12 14:41:02.963'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:42:42.573'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:45:53.367'
	UNION ALL
	SELECT 0.01,'2017-03-12 15:38:43.513'
	UNION ALL
	SELECT 0.01,'2017-03-12 16:15:49.777'
	UNION ALL
	SELECT 0.01,'2017-03-13 09:28:25.220'
	UNION ALL
	SELECT 0.01,'2017-03-14 12:06:45.000'

SELECT CONVERT(CHAR(10),sDate,120) as [day],SUM(cnt) AS [sum] 
FROM @t WHERE sDate>DATEADD(DAY,-7,'2017-03-19')	--起始日期你自己改
GROUP BY CONVERT(CHAR(10),sDate,120)
/*
day	        sum
2017-03-12	0.05
2017-03-13	0.01
2017-03-14	0.01
*/

[我还在下面游泳呢]

引用 1 楼 yenange 的回复:

DECLARE @t TABLE(cnt DECIMAL(10,2),sDate DATETIME)
INSERT INTO @t
	SELECT 0.01,'2017-03-12 14:41:02.963'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:42:42.573'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:45:53.367'
	UNION ALL
	SELECT 0.01,'2017-03-12 15:38:43.513'
	UNION ALL
	SELECT 0.01,'2017-03-12 16:15:49.777'
	UNION ALL
	SELECT 0.01,'2017-03-13 09:28:25.220'
	UNION ALL
	SELECT 0.01,'2017-03-14 12:06:45.000'

SELECT CONVERT(CHAR(10),sDate,120) as [day],SUM(cnt) AS [sum] 
FROM @t WHERE sDate>DATEADD(DAY,-7,'2017-03-19')	--起始日期你自己改
GROUP BY CONVERT(CHAR(10),sDate,120)
/*
day	        sum
2017-03-12	0.05
2017-03-13	0.01
2017-03-14	0.01
*/

SQL 我写出来了，但是要把这个SQL转换为linq不会，还请指教指教

[吉普赛的歌]

引用 2 楼 qq_33634858 的回复:

[quote=引用 1 楼 yenange 的回复:]

DECLARE @t TABLE(cnt DECIMAL(10,2),sDate DATETIME)
INSERT INTO @t
	SELECT 0.01,'2017-03-12 14:41:02.963'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:42:42.573'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:45:53.367'
	UNION ALL
	SELECT 0.01,'2017-03-12 15:38:43.513'
	UNION ALL
	SELECT 0.01,'2017-03-12 16:15:49.777'
	UNION ALL
	SELECT 0.01,'2017-03-13 09:28:25.220'
	UNION ALL
	SELECT 0.01,'2017-03-14 12:06:45.000'

SELECT CONVERT(CHAR(10),sDate,120) as [day],SUM(cnt) AS [sum] 
FROM @t WHERE sDate>DATEADD(DAY,-7,'2017-03-19')	--起始日期你自己改
GROUP BY CONVERT(CHAR(10),sDate,120)
/*
day	        sum
2017-03-12	0.05
2017-03-13	0.01
2017-03-14	0.01
*/

SQL 我写出来了，但是要把这个SQL转换为linq不会，还请指教指教[/quote] 不必强求。linq对于复杂的SQL本身就无能为力， 花那么大心思东搞西搞还不如直接用 SQLHelper 来实现。 简单的用 linq, 复杂的用 SQLHelper 两个都用就是了， 你最终的目的是完成任务， 实现功能， 不是在某种技术上吊死。

[我还在下面游泳呢]

引用 2 楼 qq_33634858 的回复:

[quote=引用 1 楼 yenange 的回复:]

DECLARE @t TABLE(cnt DECIMAL(10,2),sDate DATETIME)
INSERT INTO @t
	SELECT 0.01,'2017-03-12 14:41:02.963'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:42:42.573'
	UNION ALL
	SELECT 0.01,'2017-03-12 14:45:53.367'
	UNION ALL
	SELECT 0.01,'2017-03-12 15:38:43.513'
	UNION ALL
	SELECT 0.01,'2017-03-12 16:15:49.777'
	UNION ALL
	SELECT 0.01,'2017-03-13 09:28:25.220'
	UNION ALL
	SELECT 0.01,'2017-03-14 12:06:45.000'

SELECT CONVERT(CHAR(10),sDate,120) as [day],SUM(cnt) AS [sum] 
FROM @t WHERE sDate>DATEADD(DAY,-7,'2017-03-19')	--起始日期你自己改
GROUP BY CONVERT(CHAR(10),sDate,120)
/*
day	        sum
2017-03-12	0.05
2017-03-13	0.01
2017-03-14	0.01
*/

SQL 我写出来了，但是要把这个SQL转换为linq不会，还请指教指教[/quote] 嗯，好的，谢谢

[shadowpj]

select convert(char(10),sDate,120) as ‘每天日期’,sum(count) as '合计' from 表 group by convert(char(10),sDate,120) order by convert(char(10),sDate,120)