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 vote149 views1 answer
Creating sqeuence in oracle database
SQL
0 vote100 views1 answer
Sql server remove 0 from left
SQL
0 vote104 views1 answer
Create table sql generator
SQL
0 vote112 views1 answer
Oracle query to find schema you are working on
SQL
1 vote111 views1 answer
Sql server update column based on another table
SQL
16 votes109 views6 answers
Python sqlite
SQL
0 vote100 views1 answer
Psql check if value in array
SQL
1 vote97 views1 answer
Psql lst trigger
SQL
2 votes113 views2 answers
Sql query to copy data from one column to another
SQL
1 vote164 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL