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 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote196 views1 answer
Nvl2 syntax
SQL
0 vote208 views1 answer
Remove mysql from centos 7
SQL
0 vote187 views1 answer
MySQL import data from large CSV file
SQL
3 votes169 views1 answer
Oracle detect invalid password
SQL
0 vote173 views1 answer
Sql server select top 2 of each group
SQL
0 vote176 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote168 views1 answer
Postgresql array to rows
SQL
0 vote149 views1 answer
Delete all rows from table sqlite
SQL
3 votes229 views4 answers
Postgresql change timezone on timestamp without timezone
SQL