Ms sql skip take

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

Similar codes

0 vote202 views1 answer
Query params sql insert python f string
SQL
22 votes214 views3 answers
SQL CHEATSHEET
SQL
0 vote208 views2 answers
Mysql calcular idade
SQL
0 vote280 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
-2 votes245 views1 answer
Trunc in sql
SQL
6 votes207 views3 answers
Check if string contains substring sql
SQL
0 vote177 views1 answer
Ms sql database data size
SQL
0 vote197 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote222 views2 answers
Mysql show foreign keys
SQL
3 votes197 views2 answers
Postgres alter table owner
SQL