取20-30条数据常用的2种写法

 取20-30条数据常用的2种写法

方法一：

select top 10 * from [User] where ID>
(select max(ID) from (select top 20 ID from [User] order by ID ASC ) t0)
order by ID ASC

方法二：

select * from (
select ROW_NUMBER() OVER (ORDER BY ID ) AS RowNumber , * from [User]
)TMP
where RowNumber >20 and RowNumber<=30