SQL SERVER 分页查询

    Select Top 20 * From (Select row_number() over(order by id) as rownumber,* From Table1) temp_row Where rownumber >(( 1 - 1 )*20)

       SQLSERVER 2008以上版本有效！