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 vote167 views1 answer
Postgresql select fast check no rows
SQL
0 vote165 views1 answer
Drop specific row postgresql
SQL
0 vote169 views1 answer
If column value is null then in mysql
SQL
0 vote185 views1 answer
To Create directory
SQL
3 votes175 views4 answers
Stop MySQL
SQL
0 vote178 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote155 views1 answer
Mysql select row with max value group by
SQL
16 votes188 views3 answers
Get count of duplicate records
SQL
14 votes216 views5 answers
Set password for postgres user ubuntu
SQL
0 vote199 views1 answer
SQLServerException.makeFromDatabaseError
SQL