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 vote152 views1 answer
Sqlite löschen einer tabelle
SQL
4 votes153 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote168 views1 answer
Replace sqlalchemy
SQL
0 vote150 views2 answers
Timing sql queries
SQL
0 vote133 views1 answer
Pgadmin see indexes
SQL
0 vote162 views1 answer
Mysql c commands
SQL
0 vote161 views1 answer
Show all mongodb
SQL
0 vote100 views1 answer
Check sql query executed wp
SQL
8 votes136 views1 answer
Today minus 15 days postgresql
SQL
16 votes155 views1 answer
Mssql int max value
SQL