Choose an Isolation Level

A report reads the same row twice in one transaction and must always see the same value, even if another transaction commits a change in between. Which isolation level is the minimum that guarantees this, and how do you set it?

Table schema

Accounts(id INT PRIMARY KEY, balance INT)

Sample data

Transaction A reads balance twice; transaction B updates the balance and commits between the two reads.