mybatis使用row

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'