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 votes142 views1 answer
Sql string_agg
SQL
0 vote81 views1 answer
Ms sql print more than 1 variable
SQL
8 votes127 views1 answer
Ltrim sql
SQL
8 votes126 views2 answers
Select table column name in sql
SQL
3 votes128 views2 answers
WhereIn SQL
SQL
3 votes211 views1 answer
Oracle show trigger code
SQL
4 votes117 views1 answer
Search column by name mysql
SQL
13 votes134 views1 answer
Select count of distinct values sql
SQL
5 votes120 views2 answers
Sql conn
SQL
0 vote132 views1 answer
Mysql max number not returning correct value
SQL