22,210
社区成员
发帖
与我相关
我的任务
分享
select * from a t
where a3 between '2010-07-02' and '2010-07-11'
and not exists(select 1 from a where a2=t.a2 and a3>t.a3 )
----------
a1 a2 a3 a4
----------
14 20 2010-07-11 00:00:00.000 admin
12 20 2010-07-02 00:00:00.000 admin
11 20 2010-07-01 00:00:00.000 admin
13 21 2010-07-01 00:00:00.000 admin
--> 测试数据:@tb
declare @tb table([a1] int,[a2] int,[a3] datetime,[a4] varchar(5))
insert @tb
select 11,20,'2010-07-01','admin' union all
select 12,20,'2010-07-02','admin' union all
select 13,21,'2010-07-01','admin' union all
select 14,20,'2010-07-11','admin'
select * from @tb ORDER BY a2,a3 DESC