ASP.NET Solutions
Pages
Home
Contact US
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment