sql 常用的三种分页模式

查询第二页，每页十条

1. not in 模式

          select  top 10 * from table1 where GUID not in (select top 10 *   from table1 order by GUID)

2.二次翻转模式

          select top 10 * from (select top 20 * from table1 order by GUID desc) order by GUID asc

3.rowNumber 模式

 with _t1  as

(

       select ROW_NUMBER over(order by GUID) as rowNumber , *  from table1

) 

 select * from  _t1 where  rowNumber between 10 and 20 order by rowNumber