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

0 vote328 views1 answer
Mysql command prompt date insert format
SQL
0 vote356 views1 answer
Postgresql create query
SQL
1 vote335 views1 answer
How to give access to database in postgresql server to another user
SQL
3 votes342 views4 answers
Mysql decimal
SQL
0 vote380 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote356 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote340 views1 answer
Oracle drop default value
SQL
2 votes395 views2 answers
Create temporary table in mysql
SQL
1 vote351 views1 answer
Delete specific row in sql
SQL
1 vote333 views1 answer
Real world example of nosql
SQL