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 vote172 views1 answer
How to reset table in sql server
SQL
4 votes205 views3 answers
NOT NULL SQL
SQL
0 vote173 views1 answer
Postgresql newline character
SQL
0 vote178 views1 answer
Procedure excute monthly oracle
SQL
1 vote191 views1 answer
Update foreign key value in mysql
SQL
9 votes175 views2 answers
Default number in sql
SQL
4 votes175 views1 answer
Oracle session date format
SQL
0 vote214 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote135 views1 answer
Check sql query executed wp
SQL
0 vote169 views1 answer
Mysql get 2nd value in comma separated list
SQL