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 votes365 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote384 views1 answer
Get role postgres
SQL
0 vote362 views1 answer
Postgres list all stored procedures query
SQL
0 vote334 views1 answer
Get number of tables in database sql
SQL
0 vote298 views1 answer
Mysql offset from bottom
SQL
0 vote381 views1 answer
Mysql change default collation
SQL
0 vote343 views1 answer
Custom row number
SQL
0 vote354 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote378 views1 answer
Prisma transaction
SQL
0 vote368 views1 answer
SQL check if record exist
SQL