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

3 votes196 views2 answers
Plsql print
SQL
0 vote234 views1 answer
Time in sql server
SQL
0 vote232 views1 answer
Select count postgres double row count > 1
SQL
0 vote206 views1 answer
How to check common records in 2 table
SQL
0 vote190 views1 answer
Sql roll up rows into columns
SQL
1 vote192 views1 answer
Where date = max(date) in sql
SQL
0 vote203 views1 answer
10000000000000000000 am to meters
SQL
0 vote190 views1 answer
Set column in all row mysql
SQL
0 vote324 views3 answers
Osx stop mysql service
SQL
14 votes195 views2 answers
Oracle add column with default value
SQL