You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the ggl_links table:

SELECT * FROM ggl_links WHERE id >= 250;

 ID URL    NOTES  COUNTS CREATED

----- --------------------- ----------- ------- ---------

 1250 Retail Sales.com Wrong URL  500 07-MAY-06

 1260 Recruiting.com  Wrong URL  520 07-MAY-06

 1270 Payroll.com   Wrong URL  540 07-MAY-06

DELETE FROM ggl_links WHERE id >= 250;

3 row deleted.

SELECT * FROM ggl_links WHERE id >= 250;

no rows selected