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

4 votes343 views2 answers
Sql table
SQL
0 vote357 views1 answer
Postgres type equivalent to timespan c#
SQL
8 votes368 views1 answer
Script to add datafile to tablespace
SQL
0 vote319 views1 answer
Mysql create table columns with spaces
SQL
13 votes358 views1 answer
Select count of distinct values sql
SQL
7 votes343 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote363 views1 answer
Lost connection to mysql
SQL
1 vote395 views2 answers
Mysql limit offset
SQL
0 vote380 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote344 views1 answer
If exist column in table drop sql query mysql
SQL