UPDATE Statement Example

This example changes values in the ReportsTo field to 5 for all employee records that currently have ReportsTo values of 2.

UPDATE Employees SET ReportsTo = 5 WHERE ReportsTo = 2;