row_number()得到中间的信息

select* from
(select *,row_number() over(order by code) as rownumber
from table)
as temp
where rownumber between 10 and 20