Which SQL statement modifies existing rows in a table?

Question

Advanced SQL Developer — Easy

Which SQL statement modifies existing rows in a table?

Accepted Answer

The SQL statement that modifies existing rows in a table is UPDATE. This statement allows you to change the values of specific columns in existing rows. INSERT adds new rows, MODIFY is not a standard SQL command, and ALTER is used to modify the structure of a table, not the data within it.