Here is my scenario.
Transaction 1: DML to update the Status field from Open to Closed on ABC record.
Transaction 2: SOQL is performed to retrieve the ABC record before the above DML and updates the price value. Will the Status be Closed or Open after the second DML?
If the status is Open, how can I ensure that Transaction 1 updates are not overwritten in Transaction 2 DML?