sql分页

select * from
(select row_number() over( order by  排序的列 ) rownumber,* from ( 要分页的sql语句 ) as tem) as tem2
where rownumber > 开始于第几条  and rownumber < 结束于第几条