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 vote383 views1 answer
How to make a select in sql
SQL
1 vote231 views1 answer
Find size of all DB's postgres
SQL
0 vote163 views1 answer
Stored procedures example
SQL
2 votes176 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote203 views1 answer
Mysql command line top 10
SQL
0 vote215 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote177 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote204 views3 answers
Alter schema sql server
SQL
5 votes183 views1 answer
Add column table sql default value
SQL
0 vote165 views2 answers
List all the items that have not been part of any purchase order. sql
SQL