请教sql语句的编写

[gh102]

部门表A
商品表B

现有A表中的23个id,到B表根据这个id中去查询商品,只查询每个id的前10条数据。
如何用一条SQL语句实现?

[骑着蜗牛去爬山]

select * from(select *,row=row_number()over(partition by a.id order by getdate()) from( select * from a join b on a.id=b.id )tt)t where row<11

[哥眼神纯洁不]

select * from （select number=row_number() over(partition by id),* from B
/*此处填写排序列*/）a where number<=10

[gh102]

自己已经解决,谢谢楼上的回答 select * from (b.Name from b where b.id=.. order by b.id limit 1,3) UNION select * from (b.Name from b where b.id=.. order by b.id limit 4,2)