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

6 votes328 views2 answers
Database url postgres
SQL
14 votes336 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote329 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote347 views1 answer
Limit in access query
SQL
2 votes355 views1 answer
Mysql trigger after update
SQL
1 vote324 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote315 views1 answer
TSQL function split string
SQL
0 vote313 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote365 views1 answer
Create-table-with-index-organization
SQL
1 vote326 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL