limit i,j,代表从i+1条开始,展示j条数据
假如查找入职员工时间排名倒数第三的员工,代码如下
select * from employees order by hire_date desc limit 2, 1
假如正常开发的时候前端传递pageIndex为1,pageSize为10,代表第一页每一页10条数据
jdbcTemplate.queryForList(sql.toString() + " limit " + (pageIndex - 1) * pageSize + "," + pageSize, paramList.toArray());
01-13
3050