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 vote179 views1 answer
Get employees if not contains in sql
SQL
33 votes182 views6 answers
Sql delete
SQL
0 vote163 views1 answer
Create table employees oracle
SQL
2 votes223 views1 answer
Username sql
SQL
0 vote185 views1 answer
Soql queries for not contact related account records in salesforce
SQL
1 vote179 views1 answer
Backup mysql data only
SQL
1 vote184 views2 answers
Oracle list service names
SQL
1 vote192 views1 answer
Mysql get max value and id
SQL
0 vote224 views1 answer
Count column of tables psql
SQL
0 vote196 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL