Race Condition in SQL

[@Sulerhy]

For those who are looking for solution of this problem: Increase Isolation level. Actually this case will not happening because by default SQL use Read Committed or above isolation level, so this dirty read will not be success.

[@ayushmishra-sw4po]

How to avoid this race condition ?

[@Siuuuuuuuuu85]

How to avoid ???