How can you lock record using SOQL so that it cannot be modified by other user.

we will need “FOR UPDATE” clause of SOQL.
Sample :

1	Account [] accts = [SELECT Id FROM Account LIMIT 2 FOR UPDATE];