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 vote246 views1 answer
Call object contructor and call methods of object
SQL
1 vote254 views1 answer
Mysql take number in string
SQL
0 vote227 views1 answer
List column names of multiple tables psql
SQL
0 vote238 views1 answer
Str_to_date sql server
SQL
2 votes247 views1 answer
Postgresql create schema in specific database
SQL
1 vote173 views1 answer
Convert money to varchar sql server
SQL
6 votes233 views3 answers
Date_trunc postgres
SQL
0 vote245 views1 answer
How to check database engine in mysql
SQL
0 vote202 views1 answer
Opensuse status MySQL
SQL
15 votes238 views4 answers
Mysql export database command line
SQL