Sql server pagination

Sql pagination

SELECT * FROM (
    SELECT a.*, rownum rn
    FROM (
        SELECT * FROM ORDERS WHERE CustomerID LIKE 'A%'
        ORDER BY OrderDate DESC, ShippingDate DESC
    ) a
    WHERE rownum < ((pageNumber * pageSize) + 1 )
)
WHERE rn >= (((pageNumber-1) * pageSize) + 1);

Source: stackoverflow.com

Sql server pagination

SELECT col1, col2, ...
 FROM ...
 WHERE ... 
 ORDER BY -- this is a MUST there must be ORDER BY statement
-- the paging comes here
OFFSET     10 ROWS       -- skip 10 rows
FETCH NEXT 10 ROWS ONLY; -- take 10 rows

Sql paging query

SELECT * FROM SampleFruits
ORDER BY Id
OFFSET 0 ROWS 
FETCH NEXT 7 ROWS ONLY

Pagination In Sql

--CREATING A PAGING WITH OFFSET and FETCH clauses IN "SQL SERVER 2012"
DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 2
SET @RowspPage = 10 
SELECT ID_EXAMPLE, NM_EXAMPLE, DT_CREATE
FROM TB_EXAMPLE
ORDER BY ID_EXAMPLE
OFFSET ((@PageNumber - 1) * @RowspPage) ROWS
FETCH NEXT @RowspPage ROWS ONLY;

Source: stackoverflow.com

Similar codes

0 vote229 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote176 views3 answers
How to increase size of column in sql
SQL
18 votes199 views2 answers
Sql comments
SQL
0 vote174 views1 answer
Mysql multiple primary keys
SQL
2 votes220 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
15 votes251 views4 answers
Mysql export database command line
SQL
24 votes169 views4 answers
How to add column sql
SQL
3 votes206 views2 answers
Oracle drop sequence
SQL
3 votes129 views1 answer
If 0 return null else return query mysql
SQL
0 vote195 views2 answers
Mysql add days to date
SQL