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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved