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 vote332 views1 answer
Sqlite higher or equal
SQL
1 vote350 views1 answer
Postgres set sequence value to max id
SQL
0 vote336 views2 answers
Sql server select first day of previous year
SQL
1 vote348 views1 answer
Check current sequence value postgres
SQL
7 votes383 views3 answers
Sql update where id
SQL
1 vote333 views1 answer
Sql trigger before delete
SQL
3 votes326 views1 answer
Oracle undo tablespace list by user
SQL
0 vote342 views1 answer
ORA-00942
SQL
0 vote383 views1 answer
Mysql sum per week
SQL
11 votes368 views1 answer
Ddl view
SQL