SQL Statements › DELETE › Processing › Example 2

Example 2

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

EXEC SQL
    DELETE FROM NAMETBL
    WHERE WORKDEPT = 'E1' OR WORKDEPT = 'D2'
END-EXEC