Live2D 看板娘 / Demo

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 

posted @ 2016-02-26 17:19  MChuang  阅读(1013)  评论(0编辑  收藏  举报