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 vote179 views1 answer
Select place default lat long
SQL
6 votes180 views2 answers
Oracle trigger
SQL
0 vote202 views1 answer
Renommer schema sql
SQL
3 votes166 views2 answers
Find the median in sql
SQL
6 votes189 views2 answers
Mysqldump password in file
SQL
0 vote179 views1 answer
Oracle list subpartitions
SQL
1 vote172 views2 answers
Postgresql remote connect
SQL
31 votes178 views3 answers
SQL Server change column data type
SQL
0 vote183 views1 answer
Sql server alter table add column tinyint
SQL
0 vote172 views1 answer
Mysql in clausule string array
SQL