Let’s give Richard Roe a raise.
UPDATE employees SET employee_salary=20202
WHERE employee_name='Richard Roe'
Now let’s run the SELECT command from the previous section and see if Richard Roe appears now. Indeed, Richard Roe appears now as he has a higher salary.