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

5 votes114 views2 answers
Mysqldump password
SQL
0 vote119 views1 answer
Difference between min and max date sql
SQL
0 vote115 views1 answer
Mysql search multiple tables
SQL
0 vote109 views1 answer
Vbscript create ADODB.Connection
SQL
2 votes118 views1 answer
How to check if a row is null in sql
SQL
0 vote136 views1 answer
Full outer join in mariadb mysql
SQL
0 vote126 views1 answer
Get cpu details sql
SQL
0 vote130 views1 answer
Least spark sql
SQL
62 votes154 views8 answers
Mysql add column
SQL
0 vote131 views1 answer
Update sqlite
SQL