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 vote109 views1 answer
Narural join
SQL
1 vote123 views1 answer
Get parameter value in mysql trigger
SQL
1 vote101 views1 answer
Importance of comment in mysql
SQL
0 vote119 views1 answer
Mysql order by where condition sub query
SQL
0 vote118 views1 answer
Postgre query date
SQL
1 vote114 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
36 votes127 views3 answers
Add column in mysq
SQL
10 votes122 views6 answers
Sql between
SQL
0 vote117 views1 answer
Tsql table column constraint must be uppercase
SQL
8 votes117 views1 answer
Mac restore mysql database command line
SQL