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

6 votes126 views1 answer
Phpmyadmin reset root password
SQL
1 vote142 views1 answer
Stored procedure return value
SQL
1 vote134 views1 answer
What is in condition in sql
SQL
5 votes130 views1 answer
Oracle scan source ddl
SQL
8 votes143 views2 answers
Sqlsrv default port
SQL
0 vote131 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote150 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
7 votes136 views2 answers
Mysql db size
SQL
16 votes134 views3 answers
Delete row psql
SQL
0 vote130 views1 answer
Sql count more than 1
SQL