declare @t table (id int IDENTITY(1,1), title varchar(50) )insert into @t(title) values('Ms.') insert into @t(title) values('Mrs.') insert into @t(title) values('Ms.') insert into @t(title) values('Mrs.') insert into @t(title) values('Mr.') insert into @t(title) values('Mr.') insert into @t(title) values('Mr.') insert into @t(title) values('Ms.') insert into @t(title) values('Mrs.') insert into @t(title) values('Ms.')select * from @t a where id in (select top 2 id from @t where title=a.title order by id desc) order by title,id desc
select * from TABLE a where EXISTS (select top 2 id from TABLE where title=a.title )
declare @t table
(id int IDENTITY(1,1),
title varchar(50)
)insert into @t(title) values('Ms.')
insert into @t(title) values('Mrs.')
insert into @t(title) values('Ms.')
insert into @t(title) values('Mrs.')
insert into @t(title) values('Mr.')
insert into @t(title) values('Mr.')
insert into @t(title) values('Mr.')
insert into @t(title) values('Ms.')
insert into @t(title) values('Mrs.')
insert into @t(title) values('Ms.')select * from @t a
where id in (select top 2 id from @t where title=a.title order by id desc)
order by title,id desc
select * from TABLE a
where EXISTS (select top 2 id from TABLE where title=a.title )