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 vote165 views1 answer
Update having mysql
SQL
0 vote162 views1 answer
Sql delete where x or y or z
SQL
0 vote167 views1 answer
Bigquery declare
SQL
0 vote161 views1 answer
Shrink database file in sql server
SQL
0 vote173 views1 answer
Linked server delete openquery
SQL
0 vote252 views1 answer
Python mysql check if database exists
SQL
0 vote179 views1 answer
Copy data from one postgres container to another
SQL
0 vote169 views1 answer
Flexible search query delete table
SQL
0 vote331 views1 answer
Install mysql on bash
SQL
0 vote188 views1 answer
Sql waitfor
SQL