mybatis分页查询

  |   0 评论   |   0 浏览 
SELECT *
FROM(
	SELECT row_.*,
		rownum rownum_
    FROM(
		SELECT 
			a.*
        FROM table_name a
        WHERE a.del_flag = '0'
        ORDER BY  a.update_date DESC 
	) row_
    WHERE rownum <= (#{pageNo}-1)*#{pageSize}+#{pageSize}
)
WHERE rownum_ > (#{pageNo}-1)*#{pageSize}