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 |
+---------------------+