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 vote124 views1 answer
Create a table from one field of another table
SQL
10 votes156 views4 answers
Inner join in update query mysql
SQL
9 votes128 views3 answers
Sql delete where in
SQL
1 vote130 views1 answer
Oracle list datafiles in tablespace
SQL
2 votes121 views2 answers
How to create an empty table from an existing table
SQL
0 vote128 views1 answer
Oracle character index
SQL
12 votes214 views2 answers
Find duplicates mysql column
SQL
8 votes141 views1 answer
Show mysql user table
SQL
0 vote119 views1 answer
Search In the Database using Text
SQL
0 vote147 views1 answer
Mariadb disable foreign key checks
SQL