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

1 vote316 views1 answer
Mysql get last insert id
SQL
9 votes382 views2 answers
Convert data type in sql
SQL
0 vote365 views1 answer
Normalization in database
SQL
0 vote349 views1 answer
Datagrip go to line
SQL
9 votes336 views1 answer
Oracle get table schema
SQL
1 vote356 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote332 views6 answers
In sql
SQL
0 vote364 views1 answer
Check connections to database postgres
SQL
2 votes348 views1 answer
When matched in sql server
SQL
0 vote357 views1 answer
Create boolean column in MySQL with false as default value?
SQL