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

1 vote281 views1 answer
Timestamp in sqlite
SQL
0 vote317 views1 answer
Cartesian product sql
SQL
3 votes304 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote272 views1 answer
Sql server update top n records
SQL
1 vote286 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote277 views1 answer
Login failed for login due to trigger execution
SQL
10 votes281 views4 answers
Join with multiple conditions sql
SQL
1 vote309 views2 answers
Extract weekday from date in sql
SQL
2 votes287 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote298 views2 answers
Oracle ora-00054 how to unlock
SQL