SELECT
<include refid="Base_Column_List"/>
FROM
(
SELECT
TOP ${pageNum*pageSize}
<include refid="Base_Column_List"/> ,
ROW_NUMBER () OVER (ORDER BY id desc) row
FROM
table
) t
WHERE
t.row > ${(pageNum-1)*pageSize}
mybatis中,sqlserver分页总结
于 2019-01-30 10:53:48 首次发布