Deleting Records Answers

1. Jonie Weber-Williams just quit, remove her record from the table:

   delete 
     from myemployees_ts0211
     where lastname = 
       'Weber-Williams';

2. It's time for budget cuts. Remove all employees who are making over 70000 dollars.

   delete 
     from myemployees_ts0211
     where salary > 
       70000;

Back to Deleting records