Show Me
 

Updating Multiple Rows
Using SQL

Previous previous|next Next Page

You can use one UPDATE statement to modify multiple records in a table based on a specific condition. When a condition is not specified, the entire table is updated.

Watch Sheila update rows in the EMPLOYEES table.

 

Launch Demonstration

Show Me and Try It