if exists(select convert(varchar(10),rTime,120) as dd
from tblRecord where uID=员工uID
group by convert(varchar(10),rTime,120)
having count(1)>2)
begin
print '超过两条'
end
from tblRecord where uID=员工uID
group by convert(varchar(10),rTime,120)
having count(1)>2)
begin
print '超过两条'
end
group by uID
having count(1)>2
uId
from
tblRecord
group by
uId
having count(rTime)>1
order by
uId
datepart(dd,rTime)
from
tblRecord
Where uId="员工"
group by
datepart(d,rTime)
having count(rTime)>2
from tblrecord
group by uid,convert(char(8),rtime,112)
having count(*) >2
from tblrecord
group by uid,convert(char(10),rtime,120)
having count(*) >2
from tblrecord
group by uid,convert(char(8),rtime,112)
having count(*) >2