Free Newsletters:
DatabaseDaily
 

SQLCourse
Interactive Online SQL Training

Search Database Journal:

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



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>>