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 votes131 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
14 votes131 views2 answers
Oracle limit rows
SQL
0 vote126 views1 answer
Drop a field in psql django
SQL
3 votes123 views1 answer
Mssql remove column
SQL
1 vote148 views1 answer
Sql server if exists update else insert
SQL
0 vote119 views1 answer
Mysql date minus 1 day
SQL
3 votes130 views1 answer
Get all elements sql
SQL
1 vote121 views1 answer
Find logged in users mysql
SQL
1 vote128 views1 answer
Sqlite create index
SQL
0 vote154 views1 answer
Local pg_sql to heroku pg_sql
SQL