row_number() over 优化

回复 2# hds1999

没有order by ，完整语句是这样子的：
   select *  from (select temp.*, row_number() over() as page_control_row_number
          from (SELECT * from table1


                   where .....      

               ) temp) temp1
where page_control_row_number between 1 and 20