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 vote135 views1 answer
Netstat -tln mysql
SQL
0 vote131 views1 answer
Oracle insert single quote in string
SQL
0 vote119 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
3 votes118 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote120 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote155 views1 answer
Sql create and grant user access to database
SQL
3 votes133 views2 answers
How to delete git repo locally
SQL
0 vote123 views1 answer
Install sql server windows 10
SQL
1 vote135 views1 answer
Add multiple row table pl sql
SQL
0 vote243 views1 answer
Power bi connect to postgresql
SQL