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

1 vote211 views1 answer
Mysql size int
SQL
0 vote195 views1 answer
Sql select most frequent value in group
SQL
0 vote227 views1 answer
"Hello User Name"
SQL
1 vote202 views1 answer
Mysql pretty date format
SQL
0 vote204 views1 answer
Difference between db.query and db.execute
SQL
0 vote202 views1 answer
Pgadmin see indexes
SQL
0 vote206 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
-1 vote210 views1 answer
How to create foreign key in sql server management studio
SQL
7 votes206 views1 answer
Sql server convert string to date
SQL
2 votes205 views2 answers
How to check database username and password in postgresql
SQL