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 vote145 views1 answer
Changer un mot de passe mysql
SQL
0 vote212 views1 answer
Replace null value within column mysql
SQL
0 vote138 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote109 views1 answer
Oracle boolean to varchar
SQL
0 vote145 views1 answer
Acual month sql
SQL
3 votes143 views2 answers
Mysql add 2 hours
SQL
0 vote222 views1 answer
Run docker container with database as rds metabase
SQL
0 vote148 views2 answers
Update all columns in one update
SQL
0 vote149 views1 answer
Change date format in oracle query
SQL
1 vote232 views1 answer
Oracle datafile max size 32gb
SQL