SQL Statements › DELETE › Example 2

Example 2

Delete several rows from table NAMETBL, specifically, those for all employees in Department E1 or D2.

      DELETE FROM NAMETBL
      WHERE WORKDEPT = 'E1' OR WORKDEPT = 'D2'