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 vote209 views1 answer
Select not matching data from two tables
SQL
2 votes213 views1 answer
Oracle number to percentage
SQL
0 vote223 views1 answer
Regex any word except sql
SQL
0 vote215 views1 answer
Heidisql check how much space a row
SQL
7 votes292 views2 answers
3rd height salary sql
SQL
3 votes266 views1 answer
Oracle nextval insert
SQL
4 votes208 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote181 views1 answer
Grant owner postgresql
SQL
11 votes232 views2 answers
Having clause in sql
SQL
2 votes209 views1 answer
Oracle sql drop table purge
SQL