27,580
社区成员
发帖
与我相关
我的任务
分享
declare @tb table(id int,quyu varchar(2),lastTime datetime)
insert @tb
select 1,'1','2010-05-01 12:12:12' union all
select 2,'2','2010-05-02 12:12:12' union all
select 3,'2','2010-05-10 12:12:12' union all
select 4,'3','2010-05-10 12:12:12' union all
select 5,'3','2010-05-11 12:12:12'
SELECT * FROM @tb t1 WHERE NOT EXISTS(
SELECT 1 FROM @tb t2 WHERE t2.quyu=t1.quyu AND t2.lastTime>t1.lasttime
)
/*
id quyu lastTime
----------- ---- ------------------------------------------------------
1 1 2010-05-01 12:12:12.000
3 2 2010-05-10 12:12:12.000
5 3 2010-05-11 12:12:12.000
(所影响的行数为 3 行)
*/
SELECT * FROM A T1 WHERE NOT EXISTS(
SELECT 1 FROM A T2 WHERE T2.[区域]=T1.[区域] AND T2.[时间]>T1.[时间]
)