This will delete all rows that match the WHERE criteria.
WHERE
DELETE FROM Employees WHERE FName = 'John'