SQL DELETE certain rows with WHERE


Example

This will delete all rows that match the WHERE criteria.

DELETE FROM Employees
WHERE FName = 'John'