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

1 vote383 views1 answer
Oracle extract minute from date
SQL
22 votes348 views4 answers
Show list of users in mysql
SQL
0 vote418 views1 answer
Mysql concatenate select results
SQL
7 votes391 views2 answers
Mysql check db size
SQL
0 vote350 views1 answer
Add SuperUser MySQL
SQL
1 vote352 views1 answer
Create new table in SQL from old table with data
SQL
0 vote373 views1 answer
Mysql error 1251
SQL
0 vote351 views1 answer
Display first three characters sql
SQL
1 vote358 views1 answer
Mysql copy table1 to table2
SQL
1 vote366 views1 answer
Right outer vs left outer join
SQL