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

28 votes103 views6 answers
Distinct sql
SQL
0 vote162 views1 answer
Nuget sqllite-net-pcl
SQL
1 vote159 views1 answer
Mysql sort by date column
SQL
0 vote128 views1 answer
Minecraft duping allowed servers
SQL
1 vote126 views1 answer
Table infromation in sql server
SQL
0 vote150 views1 answer
Mysql type for large numbers with many decimal
SQL
2 votes131 views1 answer
Postgresql change value in column
SQL
1 vote135 views1 answer
Create temporal table in sql
SQL
0 vote161 views1 answer
Login failed for user sql server
SQL
3 votes135 views1 answer
Postgres kill running query
SQL