Here is SQL to fetch the last transaction records for all users. Note that this is for Oracle (pl/sql)
SELECT *
FROM some_table t
INNER JOIN
(SELECT user_id,
MAX(record_id ) AS record_id
FROM some_table
GROUP BY user_id
) v
ON p. record_id = v. record_id;
