Sql Server 实现 Mysql Limit 功能

select top 5 * from B2BProducts where DealerID = '26'
and id not in (
select top 5 id from B2BProducts where DealerID = '26'
)

 

用Top