Delete Entry from Table

Now let us remove the employee with the maximal salary; that will be Jane Roe (Figure 17). We will execute the following SQL command:

DELETE FROM employees 

WHERE employee_salary = (SELECT max(employee_salary) FROM employees)

We will run the previous SELECT again to see what we get now:

As expected, Jane Roe was deleted.