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 vote151 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
94 votes227 views4 answers
Create database postgres
SQL
0 vote145 views1 answer
Vowels in sql
SQL
52 votes646 views6 answers
Rename column sql
SQL
1 vote139 views1 answer
Sql server reseed single table
SQL
0 vote149 views1 answer
Change date format in oracle query
SQL
0 vote144 views1 answer
Postgresql create table many-to-many
SQL
0 vote182 views1 answer
Find wordpress version in database
SQL
0 vote146 views1 answer
What is the difference between now() and current_date()?
SQL
12 votes181 views6 answers
Distinct in sql server
SQL