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 vote191 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
12 votes179 views4 answers
SQL Where
SQL
3 votes202 views1 answer
Null sql
SQL
2 votes216 views1 answer
Install postgresql centos 5
SQL
16 votes214 views3 answers
Get count of duplicate records
SQL
0 vote195 views1 answer
Sql sum show 0 result
SQL
1 vote209 views3 answers
Divide by zero error in sql
SQL
3 votes189 views1 answer
V$session not found in oracle
SQL
0 vote198 views1 answer
Enable Rabbitmq management plugin
SQL
4 votes219 views2 answers
Float postgres
SQL