DELETE
A DML statement that removes rows from a table. It deletes data, not structure: DROP TABLE removes the table itself, and TRUNCATE TABLE removes all rows but keeps the table.
DELETE FROM rental
WHERE rental_id = 1;
When to use
The reading's exam tips list 'DELETE removes data, DROP removes structure'. It also warns that DELETE or UPDATE without WHERE hits every row.
See Read 01.