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 vote318 views1 answer
Mysql multiple count
SQL
0 vote290 views1 answer
Mysql find non alphanumeric characters
SQL
6 votes316 views2 answers
Stored procedure to delete data from table in mysql
SQL
2 votes326 views4 answers
2nd highest salary in mysql
SQL
0 vote426 views1 answer
Oracle db timestamp auto add
SQL
1 vote318 views1 answer
Access the postgres psql
SQL
0 vote298 views1 answer
Search db for table name
SQL
0 vote328 views1 answer
Postgresql auto increment not working
SQL
6 votes365 views2 answers
How to get last element sql
SQL
2 votes329 views4 answers
Mysql get all tables row count
SQL