row_number()函数的使用

 row_number()可以查找主键不相连的数据

select * from (select row_number()over(order by peopleId desc) as rowNum ,* from T_People)as tb where rowNum between 21 and 30