Updating Data in SQL

 Updating Data in SQL

To update data in a table, we use the UPDATE statement. Here's an example:

sql

UPDATE employees

SET department = 'Finance'

WHERE name = 'John Doe';

In this example, we're updating the department column of the employee with the name "John Doe" to "Finance".