SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY id DESC)
AS Row, * FROM table1)
AS RowNumbers
WHERE Row >= 1 AND Row <= 5
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY id DESC)
AS Row, * FROM table1)
AS RowNumbers
WHERE Row >= 6 AND Row <= 11
CREATE PROCEDURE dbo.AamirHasan
@PageIndex INT,
@PageSize INT
AS
BEGIN
WITH LogEn AS (
SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)
AS Row, *
FROM members)
SELECT *
FROM LogEn
WHERE Row between
(@PageIndex - 1) * @PageSize + 1 and @PageIndex*@PageSize
END
Author:
Aamir Hasan औथोर:
आमिर हसन أثر
أمير حسن .
61422c8a-220f-4356-b73b-14f28f114548|0|.0
ALL, SQL 2005 & 2008
sql