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:

-- view rows to be deleted

SELECT id, url, notes, counts FROM ggl_links

WHERE id > 300

GO

id url notes counts

801 www.rendc.org Wrong 1202

802 www.rendc.org/html Wrong 1204

803 www.rendc.org/sql Wrong 1206

-- delete multiple rows

DELETE FROM ggl_links WHERE id > 300

GO

(3 row(s) affected)

-- try to view the deleted row

SELECT id, url, notes, counts FROM ggl_links

WHERE id > 300

GO

no rows