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

3 votes370 views3 answers
Sql last week
SQL
3 votes370 views1 answer
Oracle sleep
SQL
1 vote368 views1 answer
Postgres get month name from date
SQL
0 vote315 views2 answers
Delete the last item in a table sql
SQL
7 votes370 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote383 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote355 views1 answer
Trigger value from maltiple table to single table mysql
SQL
2 votes357 views1 answer
Check isolation level in mysql
SQL
13 votes398 views4 answers
Mysql remove foreign key constraint
SQL
0 vote341 views1 answer
Import all databases mysql
SQL