select * from (select ROW_NUMBER() OVER(
order by a.表唯一ID desc
) AS RowNumber,a.* from (
SELECT * FROM 表名
) a
) as b
where b.RowNumber BETWEEN (#{page,jdbcType=VARCHAR}-1)*#{rows,jdbcType=VARCHAR}+1 and #{page,jdbcType=VARCHAR}*#{rows,jdbcType=VARCHAR}
SQLSERVER分页
最新推荐文章于 2024-07-21 22:27:18 发布