Limit sqlserver

Sql limit

LIMIT 5

Limit sqlserver

/*THIS IS FOR LIMIT*/
SELECT TOP 10 * FROM sometable
/*THIS IS FOR PAGING, ORDER BY IS REQUIRED*/
SELECT  *
FROM     sometable
ORDER BY name
OFFSET  5 ROWS 
FETCH NEXT 5 ROWS ONLY

Similar codes

0 vote320 views1 answer
Default value false mysql
SQL
0 vote312 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote328 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
9 votes338 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote343 views1 answer
Update sql sintax
SQL
0 vote295 views1 answer
Postgres create database if not exists
SQL
0 vote329 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
2 votes346 views2 answers
Get all tables using like
SQL
1 vote335 views1 answer
Mysql how to truncate table with foreign keys
SQL
-1 vote332 views1 answer
Module operator in oracle sql
SQL