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 vote169 views1 answer
How to find the most occuring in SQL
SQL
1 vote185 views1 answer
How to show index type in postgresql
SQL
18 votes179 views6 answers
Drop table if exists
SQL
0 vote269 views1 answer
Mysql show schema
SQL
0 vote176 views4 answers
Sql year
SQL
1 vote183 views1 answer
Oracle update with sequence
SQL
4 votes183 views2 answers
Oracle drop job
SQL
3 votes192 views2 answers
Wp do sql query from function
SQL
0 vote182 views1 answer
Postgres get database encoding
SQL
0 vote179 views1 answer
Sql values not in another table
SQL