34,587
社区成员
发帖
与我相关
我的任务
分享
select * from T1 a where not exists(select 1 from T1 where name=a.name and recordTime>a.recordTime)
select top 1 * from t1 order by recordTime desc
select * from t1 a where not exists(select 1 from t1 where abs(datediff(mi,recordtime,getdate()))<abs(datediff(mi,a.recordtime,getdate()))
select * from T1 a where not exists(select 1 from T1 where name=a.name and recordTime>a.recordTime)