SELECT top 20 id,zhuti FROM (select ROW_NUMBER() OVER(order by id DESC) AS rownumber,* FROM db_product_offer) AS T where T.rownumber BETWEEN (#{page}-1)*20+1 AND #{page}*20+1 AND T.offerId=#{offerId} and status='0'
mybatis使用row_number()分页(SqlServer数据库)
最新推荐文章于 2024-06-04 13:51:11 发布