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

1 vote196 views2 answers
Reset mysqli fetch_arra
SQL
0 vote197 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote208 views1 answer
Postgres declare variable
SQL
13 votes212 views4 answers
Mysql select last 10 rows
SQL
1 vote203 views2 answers
Sql drop multiple columns if exists
SQL
1 vote187 views2 answers
Difference between in and between in sql
SQL
6 votes197 views1 answer
Update left join mysql
SQL
0 vote195 views1 answer
Renommer schema sql
SQL
0 vote198 views1 answer
Take sql dump in to file
SQL
51 votes271 views6 answers
Change column name sql
SQL