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 votes99 views2 answers
Mysql user access to database
SQL
0 vote102 views1 answer
Java sql connection
SQL
0 vote97 views1 answer
Postgresql heritage
SQL
3 votes104 views3 answers
Mysql order by list
SQL
0 vote108 views1 answer
Convert .mdf to .bak
SQL
14 votes104 views2 answers
Sql cast
SQL
3 votes130 views5 answers
Foreign keys
SQL
21 votes110 views4 answers
Oracle add column
SQL
-2 votes96 views1 answer
How to open database
SQL
1 vote96 views1 answer
Data type and their numeric form
SQL