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

3 votes284 views1 answer
Query less than datetime sql
SQL
10 votes294 views2 answers
Select nextval from sequence oracle
SQL
16 votes282 views3 answers
Tsql rename column name
SQL
0 vote259 views1 answer
Sql view index
SQL
1 vote287 views1 answer
Pl sql insert into table
SQL
0 vote309 views1 answer
Select year from dual oracle
SQL
0 vote331 views3 answers
Postgres trim string
SQL
1 vote264 views1 answer
Scaffold mysql database
SQL
1 vote268 views4 answers
Between vs in sql
SQL
0 vote280 views1 answer
Sql server separar numeros por comas miles
SQL