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 vote188 views2 answers
Clauses in mysql
SQL
0 vote159 views1 answer
Sql check if column exists
SQL
0 vote233 views1 answer
Mysql get nested records
SQL
8 votes159 views2 answers
Alert table name mysql
SQL
0 vote159 views1 answer
Flexible search query delete table
SQL
2 votes234 views2 answers
How to DROP a table in mysql
SQL
3 votes145 views1 answer
Sql multiple column index
SQL
1 vote198 views1 answer
Postgresql if 0 then 1
SQL
0 vote167 views2 answers
Sql 2 way of select unique
SQL
0 vote153 views1 answer
Sql find leading space
SQL