techNote

摘要： --验证分页 --加行号 select row_number()over(order by Id) as RowNum,* from UserInfo; select row_number() over(order by Id) as RowNum,* from UserInfo; select r 阅读全文

摘要： 取数据 pageSize=10; pageIndex=1,2,3... 1-10 11-20 加列(开窗函数) row_number() over(order by id) sellect *,row_number() over (order by id) as rowNum from UserIn 阅读全文