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

24 votes197 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
18 votes235 views3 answers
Mysql add column default value
SQL
2 votes243 views1 answer
Rails execute sql
SQL
2 votes244 views4 answers
Check timezone of mysql database
SQL
0 vote235 views1 answer
Sql pad left 0
SQL
0 vote240 views1 answer
SAP Return
SQL
0 vote227 views1 answer
Mysql select where field like in list
SQL
1 vote232 views1 answer
Oracle activate job
SQL
0 vote210 views1 answer
How to increase the width of the screen in oracle
SQL
4 votes224 views1 answer
Sql any
SQL