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 vote138 views1 answer
Oracle select partition
SQL
0 vote145 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote134 views1 answer
Oracle difference between two dates in years
SQL
0 vote159 views1 answer
Sql get table last modified time
SQL
7 votes141 views1 answer
Grant schema permissions postgres
SQL
3 votes139 views2 answers
Sql get month name
SQL
4 votes145 views3 answers
Is not null sql
SQL
0 vote158 views1 answer
How to get data from 2 database
SQL
0 vote133 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote149 views1 answer
Truncate a table then insert data
SQL