13
Deletions
DELETE
FROM
PURCHASE
WHERE
seller = ‘Joe’
AND
product = ‘Brooklyn Bridge’
Factoid about SQL:
there is no way to delete only a single
occurrence of a tuple that appears twice
in a relation.
Example: