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

6 votes254 views2 answers
WHERE value IS sql
SQL
0 vote210 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
1 vote197 views1 answer
Oracle finding duplicate records
SQL
0 vote257 views1 answer
Sql to excel pgadmin
SQL
0 vote220 views1 answer
Hour differeence in mysql
SQL
0 vote191 views1 answer
How to define a save method in ruby for sql databases
SQL
8 votes224 views3 answers
SQL column name
SQL
0 vote371 views1 answer
Sql change a colum to unique
SQL
4 votes204 views1 answer
Oracle delete last row
SQL
1 vote195 views1 answer
Regular expression in sql server
SQL