-- sql 2005
1.rownum用法
select * from(
Select rownum=row_number() over(order by 1),* From table
)a where rownum between 1 and 10
2.带order by 子查询的用法
sleect * from(select TOP 100 percent * from table order id ) a