22,210
社区成员
发帖
与我相关
我的任务
分享
select t1.users,t1.times from test3 t1 , (select users,max(times) times
from test3 group by users )t2 where t1.users=t2.Users
and t1.Times <= dateadd(dd,-7,t2.times )
select * from test3 where Time <=dateadd(dd,-7,getdate())