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 vote259 views2 answers
Mysql to python pandas
SQL
8 votes260 views2 answers
Phpmyadmin default password
SQL
0 vote257 views1 answer
Drop all tables in azure sql database
SQL
0 vote219 views2 answers
Delete the last item in a table sql
SQL
-1 vote273 views5 answers
Operator in sql
SQL
4 votes261 views2 answers
Mysql how to change default charset
SQL
10 votes277 views2 answers
SQL rounding numbers
SQL
0 vote272 views1 answer
Mysql grouping functions
SQL
0 vote277 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote249 views1 answer
What does the -p flag do in mysql cli
SQL