34,837
社区成员




--按天分组
select sum(xx) from table group by convert(nvarchar(10),日期字段,120)
--
--按天排序
select sum(xx) from table group by convert(nvarchar(10),日期字段,120)
--
select CAST(CAST(CONVERT(VARCHAR(10), 日期字段, 120) AS DATETIME) AS INT) dt,sum(xx)
from table
group by CAST(CAST(CONVERT(VARCHAR(10), 日期字段, 120) AS DATETIME) AS INT)
CAST(CAST(CONVERT(VARCHAR(10), 日期字段, 120) AS DATETIME) AS INT)
select cast((CASE WHEN DATEPART(HOUR,字段) > 11 THEN DATEADD(HOUR,-12,字段)
ELSE 字段 END) as int) dt,sum(xx)
from table
group by cast((CASE WHEN DATEPART(HOUR,字段) > 11 THEN DATEADD(HOUR,-12,字段)
ELSE 字段 END) as int)
group by convert(nvarchar(10),日期字段,120)