1.
select * from 表 order by newid()2.
select top 10 * from (
select top 40 * from 表 order by ID
)t order by ID desc3. select * from 表 t
where not exists(select 1 from 表 where name=t.name and ID<>t.ID)
order by ID desc
select * from 表 order by newid()2.
select top 10 * from (
select top 40 * from 表 order by ID
)t order by ID desc3. select * from 表 t
where not exists(select 1 from 表 where name=t.name and ID<>t.ID)
order by ID desc
2.3.两条楼上的说的很清楚