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()
Copy

Arguments

None

Examples

This example calls the LAST_TRANSACTION function:

SELECT LAST_TRANSACTION();
Copy

Output:

+---------------------+
| LAST_TRANSACTION()  |
|---------------------|
| 1661899308790000000 |
+---------------------+
Copy