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 vote307 views1 answer
Custom row number
SQL
0 vote330 views1 answer
Capabilities of sql select statements
SQL
0 vote270 views1 answer
Mysql timeout 30 seconds
SQL
0 vote311 views1 answer
Ubuntu connect to mssql database
SQL
7 votes304 views1 answer
Sql server convert string to date
SQL
2 votes299 views1 answer
Possgress drop if exists table
SQL
6 votes324 views3 answers
Mysql create database utf8
SQL
14 votes314 views1 answer
Sql value of string
SQL
-1 vote298 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
5 votes300 views1 answer
Ignore duplicate rows in sqlite
SQL