Update command in SQL

Question

I'm currently trying to update an amount.

update Stipend
set Amount = Amount * 1.4
where SubjectId IN ('10111','20022','30033') ;

The update is able to run correctly but the only thing that does not get updated is SubjectId '10111', as the amount stays the same.

Before:

After:

Alessio Cantarella · Accepted Answer · 2019-12-05 00:38:55Z

1

You have a typo: in your query you have 10111, but the SUBJECTID you want to update is 10011.

answered Dec 5, 2019 at 0:38

5,2413 gold badges31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1