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 vote355 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote322 views1 answer
PSQL qith variables
SQL
0 vote362 views1 answer
Get statis values sql
SQL
0 vote353 views3 answers
Postgres date difference seconds
SQL
1 vote344 views1 answer
Drop column if exists sql server
SQL
0 vote357 views1 answer
Count columns psql(PostreSQL)
SQL
22 votes327 views3 answers
Join three tables sql
SQL
0 vote375 views1 answer
"Hello User Name"
SQL
0 vote327 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote364 views1 answer
Pl/pgsql declare variable
SQL