The Repeatable Read isolation level permits a transaction to obtain read locks on all rows of data that it returns to an application, and write locks on all rows of data that it inserts, updates, or deletes. By using the Repeatable Read isolation level, SELECT statements issued multiple times within the same transaction will always yield the same result. A transaction using the Repeatable Read isolation level can retrieve and manipulate the same rows of data as many times as needed until it completes its task. However, other transactions can insert, update, or delete a row of data that would affect the result table being accessed until the isolating transaction releases its locks.