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 vote218 views1 answer
Sql server isnull function nor working count
SQL
0 vote223 views1 answer
Connect by query in oracle
SQL
0 vote222 views1 answer
Mysql where in keep order
SQL
0 vote243 views1 answer
Wp_query raw sql
SQL
0 vote222 views1 answer
Sql server alter table column nullable
SQL
0 vote250 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote228 views1 answer
Mysql select and count left join
SQL
6 votes206 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
1 vote235 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote214 views1 answer
Sqlite create index
SQL