Sql2005实现RowNUMBER分页

SQL语句：

Select * From (Select (ROW_NUMBER() OVER(ORDER BY ID asc)) AS rownum,* From [TABLENAME]) t

Where rownum BETWEEN 1 AND 20 

说明：这个是显示前20条记录，

rownum：是显示行数的列；

ID：表TABLENAME的排序字段