What if we only want to delete a specific number of rows?

THE ABOVE syntax for the delete from with limit was not working for me. Why?

SSMS VERSION: SQL Server Management Studio(15.0.18206.0)


Any useful info will be helpful?

No idea, according to the documentation:

https://www.got-it.ai/solutions/sqlquerychat/sql-help/general-sql/msg-102-level-15-state-1-line-n-incorrect-syntax-near/

an improper operator is possible, but LIMIT looks like its properly spelled

1 Like