Updating Multiple Columns

Question

Why do we have to specify Name and ID ? isn't it enough to specify just the ID since we can be sure there won't be any duplicate entries using Where ID...?

here's the example:

UPDATE Employees
SET Salary=5000, FirstName='Robert'
WHERE ID=1;

Answer 1

In the example query salary and first-name values are being updated where ID =1
condition for filtering will be after where keyword

Answer 2

Ah thanks mate! I was confused, but seeing it with fresh eyes now makes sense :)