谢谢大家!不过你们的都没有彻底解决此问题。
我自己搞定了。
Select UserID,convert(char(10),LoginTime,120) Date ,count(*) Count
From table1
Where convert(char(21),logintime,120)
Between convert(char(10), logintime,120)+' 07:00:00.000'
And convert(char(10), logintime,120)+' 09:00:00.000'
select userid,convert(char(10),logintime,120)
,count(*) 次数
from table1 where datepart(hh,logintime) between 7 and 10
group by userid,convert(char(10),logintime,120)
DECLARE @dt_DateTime datetime
SET @dt_Datetime='2003-08-28'
SELECT UserID,Count(*) AS DLCount,@dt_Datetime AS DLRQ
FROM OPS_Log
WHERE Datediff(day,LoginTime,@dt_Datetime)=0
AND DATEPART(Hour,LoginTime)>=7
ANd DATEPART(Hour,LoginTime)<=10
GROUP BY UserID
每一天的.
select userid,convert(char(10),logintime,120)
,sum(case when right(convert(char(17),logintime,120),5)=>'07:00' and right(convert(char(17),logintime,120),5)<='09:00' then 1 else 0 end ) 次数
from table1 group by userid,convert(char(10),logintime,120)
每一天的.
select userid,convert(char(10),logintime,120)
,sum(case when right(convert(char(17),logintime,120),5)=>'07:00' and right(convert(char(17),logintime,120),5)<='09:00' then 1 else 0 end ) 次数
from table1 group by userid,convert(char(10),logintime,120)
select 日期=convert(varchar(10),LoginTime,120),UserID,登录次数=count(*)
from table1
where datepart(hh,LoginTime) between 7 and 9
group by convert(varchar(10),LoginTime,120),UserID
select CONVERT(varchar(10),LoginTime,120) 日期,userid 用户id,sum(case when DATEPART(hh,LoginTime) between 7 and 9 then 1 else 0 end) 登录的次数 group by CONVERT(varchar(10),LoginTime,120),UserID
select UserID, convert(char(10), logintime, 120) 日期, sum(1) 次数 from table1
where datepart(hh, logintime) >= 7 and datepart(hh, logintime) <= 9
group by UserID, convert(char(10),
select userid
,sum(case when right(convert(char(17),logintime,120),5)=>'07:00' and right(convert(char(17),logintime,120),5)<='09:00' then 1 else 0 end ) 次数
from table1 group by userid
Select UserID, CONVERT(varchar(10), LoginTime,120),count(*)
from Table1
where convert(char(5),getdate(),108) between '07:00' and '09:00'
group by UserID, CONVERT(varchar(10), LoginTime,120)