This will delete all rows that match the WHERE criteria.

DELETE FROM Employees
WHERE FName = 'John'