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 vote323 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote350 views1 answer
Postgresql create table many-to-many
SQL
0 vote324 views1 answer
Jooq replace
SQL
0 vote318 views1 answer
Mssql describe stored procedure sqlcmd
SQL
49 votes416 views6 answers
Mysql add column to table
SQL
0 vote288 views1 answer
Mysql convert column to uppercase
SQL
0 vote325 views1 answer
Dnsmasq.conf location macos
SQL
0 vote337 views2 answers
Mysql unique two columns
SQL
1 vote324 views1 answer
Clear screen command in psql
SQL
0 vote325 views3 answers
Mysqli count down
SQL