ID如果没有断号地自增,可以用: select * from (select distinct * from dbo.t_test001 )Contact2 where id between 11 and 15
select max(id),name from (select top 5 id,name from( select top 15 id, name from dbo.t_test001 order by id asc ) Contact2 order by id desc ) as t group by name
select *
from (select distinct * from dbo.t_test001 )Contact2
where id between 11 and 15
(select top 5 id,name from(
select top 15 id, name from dbo.t_test001 order by id asc
) Contact2
order by id desc ) as t
group by
name