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

8 votes149 views5 answers
Alter table add column with default value
SQL
0 vote162 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote163 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote153 views1 answer
Inserted row count tsql
SQL
0 vote155 views1 answer
Oracle select partition
SQL
0 vote149 views1 answer
Search from comma separated values in sql server
SQL
2 votes159 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
6 votes206 views2 answers
Install psql mac
SQL
0 vote159 views1 answer
MySql get primary keys of table
SQL
0 vote144 views1 answer
Shrink database file in sql server
SQL