--> 测试数据: [T1]
if object_id('[T1]') is not null drop table [T1]
create table [T1] (A int,B varchar(4),C datetime)
insert into [T1]
select 1,'张三','2015-1-1' union all
select 2,'李四','2016-1-1' union all
select 1,'李四','2015-2-1' union all
select 2,'张三','2017-2-1'
select * from [T1]
SELECT T1.*
FROM T1
INNER JOIN T1 AS t2 ON T1.c > T2.c
AND T1.a = t2.a;
/*
A B C
1 李四 2015-02-01 00:00:00.000
2 张三 2017-02-01 00:00:00.000*/
