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 vote229 views1 answer
Mysql insert into select transaction c#
SQL
0 vote210 views1 answer
Adding primery key constraint to a column
SQL
103 votes610 views2 answers
Sql server LIKE '%%'
SQL
1 vote285 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
6 votes254 views2 answers
WHERE value IS sql
SQL
4 votes217 views1 answer
Oracle nls_date_format
SQL
-2 votes205 views1 answer
Use of where in left join in mysql
SQL
0 vote207 views1 answer
Date on SQL
SQL
10 votes268 views6 answers
Mysql set root password
SQL
0 vote198 views1 answer
Postgresql create user roles
SQL