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