You have to write procedure for this
CREATE PROCEDURE ReturnRowsAt
(
@Startpos int,@Endpos int
)
AS
Begin
DECLARE @Table1 AS TABLE (rwid bigint identity(1,1), val nvarchar(255))
INSERT INTO @Table1 (val)
SELECT * FROM yourtablename
SELECT * FROM @Table1 WHERE rwid between @Startpos and @endpos
End
Hope this helps if yes then accept and vote the answer
--Rahul D.