sql怎么写

[leven1984]

id， type 两列，id为主键 ，想取同一type的前10条数据 怎么拼sql

[AcHerat]

select *
from tb t
where id in (select top 10 id from tb where type = t.type order by id desc)

[cd731107]

select *
from tb t
where id>=any (select top 10 id from tb where type = t.type order by id desc)

[gogodiy]

;with aaa as
(select row_number() over(partition by type order by id) as row,* from table)
select * from aaa where row<=10

[undead4444]

LS+1

[agile2009]

select tb.* from tb where tb.id in (select top 10 tb1.id from tb tb1 where tb.type = tb1.type order by a,b )