SAVEPOINT

A SAVEPOINT statement in SQL identify a point in a transaction to which you can later ROLLBACK.

SAVEPOINT label;

Example 1:

SAVEPOINT savepoint1;
DELETE FROM country WHERE countrycode=34;
ROLLBACK TO SAVEPOINT savepoint1;