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 vote266 views1 answer
Reindex mssql table
SQL
1 vote256 views1 answer
Psql connections
SQL
0 vote265 views1 answer
Select the date 30 days less that the todays date sql request
SQL
3 votes272 views1 answer
DB: in eloquent using sql
SQL
28 votes215 views6 answers
Distinct sql
SQL
2 votes248 views2 answers
Install sqlalchemy
SQL
0 vote255 views1 answer
Select all tables linked server sql
SQL
4 votes320 views2 answers
Sql display today's date
SQL
0 vote288 views1 answer
Add new column in sql with foreign key
SQL
0 vote245 views1 answer
How much table store postgres
SQL