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:


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

1 Like