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 vote303 views1 answer
Sql server system messeges
SQL
1 vote300 views2 answers
Mysql trim whitespace
SQL
3 votes294 views1 answer
V$session not found in oracle
SQL
0 vote320 views4 answers
What is unique key in sql
SQL
24 votes310 views4 answers
Postgres remove database
SQL
1 vote293 views1 answer
Ilike for date postgres
SQL
0 vote291 views1 answer
Getting next sequence value jpa postgress
SQL
3 votes316 views1 answer
Oracle drop user
SQL
2 votes306 views1 answer
How to check grants on a package in oracle
SQL
0 vote318 views1 answer
Mysql backup certain tables workbench
SQL