SQLCourse
Interactive Online SQL Training
HOME News MS SQL Oracle DB2 Access MySQL PHP SQL Etc Scripts Links Forums DBA Talk
SQL Courses
1What is SQL?
2Table basics
3Selecting data
4Creating tables
5Inserting into a table
6Updating records
7Deleting records
8Drop a table
9Advanced Queries
10Standalone SQL interpreter
11Advertise on SQLCourse.com
12Database Links
13Technology Jobs
Free Newsletters:
DatabaseDaily
 


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

 

SQL Course Curriculum
<<previous 123456789 next>>