34,576
社区成员
发帖
与我相关
我的任务
分享
declare @t table(ID int,name varchar(10),time datetime)
insert into @t select 1,'name1','2007-12-8 5:00:45'
insert into @t select 2,'name1','2007-12-9 5:00:50'
insert into @t select 3,'name2','2007-12-8 5:00:45'
insert into @t select 4,'name2','2007-12-9 5:00:45'
--取最大时间的对应信息
select * from @t a where time=(select top 1 time from @t where a.name = name order by ID desc)