分页

取数据

pageSize=10;

pageIndex=1,2,3...

1-10

11-20

加列(开窗函数) row_number() over(irder by id)

sellect *,row_number() over (order by id) as rowNum from UserInfo

子查询

select * from ( select * , row_number() over ( order by id ) as rowNum from UserInfo ) as t where t.rowNum>=11 and t.rowNum<=20

先走里面子查询

再走外面

这样它就认识了rowNum字段了

这个SQL语句一定要背下来, 要记住, 死死记住, 理解它的含义