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

2 votes260 views1 answer
While loop sql
SQL
7 votes283 views5 answers
Oracle alter table
SQL
0 vote272 views2 answers
Sqlite unique
SQL
11 votes272 views1 answer
Get ddl materialized view oracle
SQL
3 votes254 views4 answers
Mysql create table from select statement
SQL
3 votes245 views1 answer
Oracle detect invalid password
SQL
0 vote229 views1 answer
Mysql timeout 30 seconds
SQL
2 votes276 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
-1 vote271 views1 answer
Mysql case when multiple conditions
SQL
0 vote266 views1 answer
Plsql check for string in numeric
SQL