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 vote111 views1 answer
Add colum date in sql
SQL
0 vote114 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote116 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote113 views1 answer
Wordpress database query change url
SQL
15 votes124 views4 answers
Pl sql
SQL
0 vote192 views1 answer
Sql database size
SQL
0 vote148 views1 answer
Sqlalchemy _in array sqlite
SQL
1 vote107 views1 answer
Mysql best tutorial for beginners
SQL
-1 vote127 views1 answer
Module operator in oracle sql
SQL
0 vote125 views1 answer
SQL Error 1040 : Too many connections
SQL