联表查询

[zp63534036]

select top 10 * from Bk_UserOrder where orderid not in (select top 10 orderid from Bk_UserOrder where 1=1 order by OrderId)
and orderfid in (select fid from tb_office where fhid=71) order by orderid



我想对OrderHid字段相同，OrderFid字段不相同的数据进行分页要怎么该上面的语句?

[开着拖拉机泡妞]

select top 10 * 
from Bk_UserOrder 
where not exists 
(select 1 from(select top 10 orderid from Bk_UserOrder where 1=1 order by OrderId)a
where a.OrderId<=b.OrderId)

[zp63534036]

答案已经想出来了，不过还是谢谢