How to fatch Next 10 record from Particular Id

You can implement in Database or C# side. Follow below code:

In SQL Server 2012 prior version:

DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 2;
SET @RowspPage = 5;
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY ID_EXAMPLE) AS NUMBER,
ID_EXAMPLE, NM_EXAMPLE, DT_CREATE FROM TB_EXAMPLE
) AS TBL
WHERE NUMBER BETWEEN ((@PageNumber - 1) * @RowspPage + 1) AND (@PageNumber * @RowspPage)
ORDER BY ID_EXAMPLE;

If you are using Microsoft SQL Server 2012 then:

Using Linq:

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
You can implement in Database or C# side. Follow below code:
In SQL Server 2012 prior version:
DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 2;
SET @RowspPage = 5;

SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY ID_EXAMPLE) AS NUMBER,
ID_EXAMPLE, NM_EXAMPLE, DT_CREATE FROM TB_EXAMPLE
) AS TBL
WHERE NUMBER BETWEEN ((@PageNumber - 1) * @RowspPage + 1) AND (@PageNumber * @RowspPage)
ORDER BY ID_EXAMPLE;
If you are using Microsoft SQL Server 2012 then:
-- You need to make it dynamic by using variables.
SELECT * FROM TableName
ORDER BY id
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;
Using Linq:
var pageSize = 10; // set your page size, which is number of records per page

var page = 1; // set current page number, must be >= 1

var skip = pageSize * (page-1);

Phrases = bannersPhrases.Select(p => p.Phrase)
.Skip(skip)
.Take(pageSize)
.ToArray();
Dr.Ajay Kashyap9y ago
Thanks Manas Mohapatra sir....
Dr.Ajay Kashyap9y ago
i have 100 records in my table from that at first payload i fetched first 10 record which are 1 to 10 ; In second payload i want to fetch next 10 record from id 11 to 20 ; then third payload i want to fetch next 10 record from id 21 to 30
Manas Mohapatra9y ago
Please describe your requirement more with an example.