Thursday, March 31, 2011

Sql Deleting Records Answers


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;

No comments:

Post a Comment

Your comment is pending for approval

AngularJS Basics - Part 1

                                                                  AngularJS What is AngularJS ·          Framework by googl...