@Prog! - ASP.NET(C#) AJAX -

WITH Table1 AS
(
    SELECT ID, Number, ROW_NUMBER() OVER(ORDER BY ID DESC) AS 'RowNumber'
    FROM Table_1
)
SELECT *
FROM Table1
WHERE RowNumber BETWEEN 5 AND 10;

ID          Number      RowNumber
----------- ----------- --------------------
5           555         5
4           444         6
3           333         7
2           2222        8
1           1111        9
0           0           10