Sql pagination offset

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

Similar codes

3 votes187 views1 answer
Mysql replace string in table
SQL
0 vote158 views1 answer
Sql date d'aujourd'hui
SQL
24 votes175 views4 answers
Mssql get all table names
SQL
0 vote179 views1 answer
How to install Firebird
SQL
0 vote205 views1 answer
Double in sql server example
SQL
0 vote167 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote184 views1 answer
Query builder doctrien return sql
SQL
4 votes163 views1 answer
What are the data types in sql
SQL
1 vote172 views3 answers
Epoch to datetime
SQL
16 votes167 views4 answers
Ascending order mysql
SQL