Paging Sql Query

select a.srno,a.packet_no from
(
select stock.*,row_number() over (order by srno) as rownumber from stock
) a

where rownumber between ((6 - 1) * 10) + 1 and 6 * 10