dcsimg

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

By submitting your information, you agree that sqlcourse.com may send you SQLCourse offers via email, phone and text message, as well as email offers about other products and services that SQLCourse believes may be of interest to you. SQLCourse will process your information in accordance with the Quinstreet Privacy Policy.

 


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