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 vote217 views1 answer
Data types mysql vs postgresql
SQL
0 vote190 views1 answer
Grant privileges of databse to user
SQL
0 vote201 views1 answer
Update view sql
SQL
7 votes189 views2 answers
Mysql get year from date
SQL
0 vote258 views1 answer
Compare two tables to find unmatched records
SQL
0 vote209 views1 answer
Sql_inner_join
SQL
0 vote196 views1 answer
Get primary key of table
SQL
1 vote182 views1 answer
Mysql check string don't have number
SQL
9 votes205 views2 answers
Sql limit to 5 results
SQL
1 vote238 views3 answers
Nth highest salary
SQL