Using QMF

Deleting rows from a table using SQL statements

Use the SQL DELETE statement to create a query to delete one or more rows from a table.

For example, the following query deletes the row for employee number 410 from the MYSTAFF table:

 DELETE FROM MYSTAFF
   WHERE ID = 410

This query deletes all rows that are associated with department 38:

 DELETE FROM MYSTAFF
   WHERE DEPT = 38