Custom Paging SP

--How custom paging Sp works

alter proc finalproc --0,10
@pageindex int,
@pagesize int
as
begin

select id,name,age,sex
 from
(
 select row_number() over (order by id) as row,id,name,age,sex from finaltable1
 )temp
 where row >= (@pageindex + 1) and row <= ((@pageindex + 1)*@pagesize)
end