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

4 votes124 views1 answer
Sql any
SQL
0 vote121 views1 answer
Excute raw query
SQL
1 vote129 views2 answers
Update with inner join sql server
SQL
3 votes130 views1 answer
Oracle transaction commit rollback example
SQL
0 vote121 views1 answer
Get who is hired in specific month in sql
SQL
1 vote143 views1 answer
Postgres see sequence current state
SQL
1 vote131 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote131 views1 answer
Postgres 11 add primary key
SQL
0 vote124 views1 answer
Backup a table in sql
SQL
5 votes121 views2 answers
Postgres update with if condition query
SQL