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 vote201 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote194 views1 answer
Stop psql server windows
SQL
0 vote215 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote248 views1 answer
Find and replace query in wordpress\
SQL
0 vote256 views1 answer
Sql select without column name
SQL
18 votes216 views3 answers
Get the list of all tables in sql server
SQL
0 vote203 views1 answer
Mysql coonect sample code
SQL
3 votes216 views2 answers
Sql server current date without time
SQL
19 votes232 views3 answers
Grant mysql
SQL
0 vote196 views1 answer
Default value false mysql
SQL