sql获取表第十一到第十五行的记录,
表中有ID和NAME字段(ID为主键),赛选掉NAME重复的数据?
我已经把记录取出来了,但不知道怎么赛选?
select top 5 id,name from(
select top 15 id, name from dbo.t_test001 order by id asc
) Contact2
order by id desc
------解决方案--------------------
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