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

5 votes195 views1 answer
Find table from column name in sql
SQL
0 vote209 views1 answer
Nodejs sql get one to many relationship as array
SQL
7 votes174 views3 answers
How to check table name in current database sql
SQL
0 vote214 views1 answer
Sql alter column name sql server
SQL
0 vote183 views1 answer
Postgresql update to unique
SQL
0 vote185 views1 answer
Default value false mysql
SQL
2 votes192 views3 answers
Sql delete duplicate
SQL
-1 vote179 views1 answer
Round up and down sql
SQL
1 vote179 views2 answers
Postgresql remote connect
SQL
-1 vote251 views1 answer
Pl sql drop trigger
SQL