Can We Use LIMIT In MSSQL ?

Forums SQLCan We Use LIMIT In MSSQL ?
Staff asked 3 years ago

Can We Use LIMIT In MSSQL ?
Not TOP().. is it possible to use LIMIT in MSSQL?

Answers (1)

Add Answer
Staff answered 3 years ago

All SQL databases do not support SELECT LIMIT. To restrict your results in databases like SQL Server or MSAccess, utilise the SELECT TOP query. Microsoft’s proprietary counterpart of the SELECT LIMIT statement is the SELECT TOP statement.

Subscribe

Select Categories