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 vote169 views1 answer
How to check even or odd in sql
SQL
10 votes151 views2 answers
Mysql select timestamp group by day
SQL
0 vote168 views1 answer
Postgresql delete multiple rows
SQL
2 votes165 views1 answer
Postgresql format date dd/mm/yyyy
SQL
2 votes181 views1 answer
Postgresql update sequence next value
SQL
0 vote189 views1 answer
Mysql extract day from date leading zero
SQL
0 vote158 views1 answer
How to find the most occuring in SQL
SQL
6 votes185 views1 answer
Oracle pl sql source
SQL
1 vote170 views1 answer
Select not matching data from two tables
SQL
18 votes169 views4 answers
Uninstall mysql ubuntu 18.04
SQL