Wednesday, February 17, 2016

SQL Query for pagination

SELECT *
FROM ( SELECT
ROW_NUMBER() OVER (ORDER BY id) as row,*
FROM tbl_Stock) a
WHERE row > 0 and row <= 20

No comments:

Post a Comment