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 votes342 views1 answer
Sql asynchronous stored procedure call
SQL
18 votes377 views3 answers
Get the list of all tables in sql server
SQL
17 votes355 views3 answers
Postgresql version command
SQL
1 vote379 views1 answer
Sql current timestamp
SQL
0 vote386 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
3 votes375 views2 answers
Tsql join multiple record in one string
SQL
11 votes373 views3 answers
Pl sql example
SQL
7 votes373 views6 answers
Mysql group concat
SQL
0 vote338 views1 answer
Mssql describe stored procedure sqlcmd
SQL
2 votes385 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL