Categories:

Context Functions (Session)

LAST_TRANSACTION

Returns the transaction ID of the last transaction that was either committed or rolled back in the current session.

See also:

CURRENT_TRANSACTION , DESCRIBE TRANSACTION

Syntax

LAST_TRANSACTION()

Arguments

None

Examples

This example calls the LAST_TRANSACTION function:

SELECT LAST_TRANSACTION();

Output:

+---------------------+
| LAST_TRANSACTION()  |
|---------------------|
| 1661899308790000000 |
+---------------------+
Back to top