Learn VisualLearn SQL

Receive Changed Rows as a Result

RETURNING on INSERT, UPDATE, or DELETE returns the affected rows. If WHERE matches several rows, both the change and the RETURNING result contain several rows.

GOAL

Predict affected rows and the RETURNING result.

If three rows are updated with RETURNING id, how many rows return?