DB2 graphic  QMF Version 8

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004