DELETE statement syntax in SQL Server

We generally write DELETE statement with FROM keyword in this way.
We have Employees table and I want to delete all records of employees
whose name is starting with ‘J%’.So statement should be as below.


Here FROM keyword is optional.
Same statement can be written as  below.



That’s It.
Enjoy Learning.