Select * from Transactions where id='1234'
How to get latest record first i.e. records in descending order
QLDB doesn't currently support ORDER BY (or LIMIT), so you'd have to execute that query and do the sort in your application code.