联表查询select top 10 * from Bk_UserOrder where orderid not in (select top 10 orderid from Bk_UserO
联表查询
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字段不相同的数据进行分页要怎么该上面的语句?
[解决办法]
- SQL code
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)awhere a.OrderId<=b.OrderId)