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

-1 vote92 views1 answer
Mysql if example
SQL
0 vote124 views1 answer
Sp in sql server
SQL
2 votes115 views2 answers
Sql first character
SQL
0 vote160 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
2 votes83 views1 answer
Latest record in sql
SQL
1 vote111 views1 answer
Postgres check blocking
SQL
0 vote128 views1 answer
Count in sql and diff
SQL
5 votes113 views2 answers
Get number of columns sql
SQL
10 votes122 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote138 views2 answers
Get value from a table an insert it with other values in another table sql
SQL