Please note that id as identity, so using count (*) do not deliver the last record but much better to use max (id).

Besides the set should be:

set salary = salary...