Sql paging query

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

Sql paging query

SELECT * FROM SampleFruits
ORDER BY Id
OFFSET 0 ROWS 
FETCH NEXT 7 ROWS ONLY

Similar codes

0 vote344 views1 answer
Express api ith mysql data
SQL
13 votes306 views5 answers
Oracle list tables
SQL
2 votes323 views1 answer
Sql alchemy or
SQL
0 vote350 views1 answer
Shrink database file in sql server
SQL
3 votes324 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote318 views1 answer
Mysqlimport
SQL
0 vote333 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote344 views1 answer
Sqlalchemy get schema from database
SQL
1 vote285 views1 answer
Strict in postgres SQL
SQL
0 vote340 views1 answer
Sql reverse order of results
SQL