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

1 vote275 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote330 views1 answer
Mariadb cast to int
SQL
5 votes294 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote240 views1 answer
Import sql file in mysql linux
SQL
4 votes280 views1 answer
To date oracle with time
SQL
0 vote300 views1 answer
Power bi union columns
SQL
0 vote325 views1 answer
Get primary key of table
SQL
-1 vote317 views5 answers
Left join
SQL
16 votes316 views6 answers
Python sqlite
SQL
4 votes289 views1 answer
Sql delete where in select
SQL