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 vote192 views1 answer
Comma seperated join mssql
SQL
10 votes193 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote186 views2 answers
How to check username in mysql command line
SQL
0 vote145 views1 answer
Check if has alpha characters sql
SQL
0 vote188 views1 answer
How to check which sp is running in sql server
SQL
3 votes190 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote195 views1 answer
Function sum(text) does not exist postgres
SQL
1 vote207 views1 answer
Dropping a constraint in ms sql
SQL
0 vote203 views1 answer
Get date from timestamp in mysql
SQL
4 votes200 views2 answers
Oracle drop job
SQL