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 vote302 views1 answer
Psql connect
SQL
3 votes264 views4 answers
Show sql server database
SQL
0 vote333 views1 answer
Postgresql alter table sequence
SQL
0 vote303 views1 answer
Oracle locked objects
SQL
1 vote289 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote288 views1 answer
How to use select union and loop
SQL
2 votes285 views1 answer
Mysql virtual column
SQL
1 vote278 views2 answers
Sql select only row with the max date
SQL
-1 vote302 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote248 views1 answer
Mysql get last insert id
SQL