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

0 vote300 views1 answer
Allow external access to mysql
SQL
18 votes290 views6 answers
Mysql create table
SQL
0 vote278 views1 answer
Sql server is not
SQL
0 vote307 views2 answers
Drop tables from local table database postgres
SQL
19 votes312 views3 answers
Grant mysql
SQL
0 vote317 views1 answer
Providername system.data. mysql
SQL
0 vote293 views1 answer
Knex last insert id mysql
SQL
0 vote296 views1 answer
Mysql sql select one day before
SQL
23 votes311 views6 answers
How to create table in sql
SQL
-2 votes283 views3 answers
Sqlite reset autoincrement
SQL