SQL: consistent lock ordering is the only cure for deadlocks

Two transactions that lock the same rows in opposite orders will eventually deadlock. Retrying helps you survive it; ordering the locks stops it happening. The database picks a victim and rolls it back with no warning.

Full code & output

This topic is available to PRO members.