sqlserver 按日分组

?

1 2 3 4 5 6 7 8

--根据日期字段AddTime，得到每日的数据量 SELECT   CAST(AddTime AS DATE) AS riqi, COUNT(*) AS TotalOrders FROM   MoJingKaKouRecord GROUP BY   CAST(AddTime AS DATE)   order by riqi desc

　　

 

?

1 2 3 4 5 6 7 8 9 10 11 12

--统计出每日的车牌数量（同一个车牌，同一天只算一次） select riqi,count(*) as num from ( SELECT   CAST(AddTime AS DATE) AS riqi, COUNT(*) AS TotalOrders FROM   MoJingKaKouRecord   GROUP BY   CAST(AddTime AS DATE),PlateNo   ) as t1   group by riqi   order by riqi desc

　　

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

--指定时间范围内的车牌总数（每个车牌每日只统计一次） select sum(num) from (         select riqi,count(*) as num from         (                 SELECT                   CAST(AddTime AS DATE) AS riqi, COUNT(*) AS num                 FROM                   MoJingKaKouRecord                 GROUP BY                   CAST(AddTime AS DATE),PlateNo           ) as t1           group by riqi   ) as t2   where riqi >='2024-9-1'  and riqi <'2024-10-1'