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

3 votes264 views5 answers
Mysql get last inserted id
SQL
0 vote245 views1 answer
Store query result in variable sql
SQL
0 vote291 views1 answer
How to generate ids in sql
SQL
0 vote287 views1 answer
Csv to sqlite python
SQL
0 vote251 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote325 views3 answers
Postgres trim string
SQL
2 votes311 views3 answers
Xampp mysql database not starting
SQL
0 vote277 views1 answer
Ms sql database data size
SQL
0 vote229 views0 answer
SQL
3 votes258 views2 answers
Mysql time
SQL