Put this query in store procedure
select * from
(
select row_number over(partition by id,name order by id,name) as index_no,
id,name
from tbl
) as a
where index_no>@StartIndex
and index_no<@EndIndex
pass parameters '@StartIndex' & '@EndIndex' range while clicking button.
eg. 1-10, 11-20,...
Happy Coding!
:)