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 vote225 views1 answer
Mariadb number format
SQL
2 votes216 views1 answer
Date_format for time sql
SQL
3 votes218 views1 answer
Sql multiple column index
SQL
0 vote249 views1 answer
Vs 2019 connect to local mysql database
SQL
7 votes237 views2 answers
What is sql clause
SQL
0 vote222 views1 answer
How to order result of subquery in select
SQL
9 votes245 views5 answers
Laravel to sql
SQL
2 votes214 views1 answer
Create table with primary key
SQL
3 votes207 views1 answer
Oracle wait
SQL
1 vote229 views1 answer
Oracle apex version view
SQL