What does `SELECT FOR UPDATE` do in SQL and when would you use it?

Question

Advanced SQL Developer — Medium

What does `SELECT FOR UPDATE` do in SQL and when would you use it?

Accepted Answer

`SELECT FOR UPDATE` acquires row-level exclusive locks on selected rows, preventing other transactions from modifying them until the current transaction finishes. It's used for pessimistic concurrency control when reading rows that will be modified within the same transaction.