Which of the following is the correct syntax to return all columns of deleted rows from a table named orders?

easy📝 Syntax Q3 of 15

PostgreSQL - Set Operations and Advanced Queries

Which of the following is the correct syntax to return all columns of deleted rows from a table named orders?

ADELETE FROM orders WHERE RETURNING *;

BDELETE FROM orders RETURNING *;

CDELETE RETURNING * FROM orders;

DDELETE FROM orders * RETURNING;

Step-by-Step Solution

Solution:

Step 1: Recall DELETE statement syntax with RETURNING
The RETURNING clause comes immediately after the DELETE statement and optional WHERE clause.
Step 2: Validate DELETE FROM orders RETURNING *;
DELETE FROM orders RETURNING *; correctly uses DELETE FROM orders RETURNING *; which returns all columns of deleted rows.
Final Answer:
DELETE FROM orders RETURNING *; -> Option B
Quick Check:
DELETE RETURNING syntax = DELETE FROM table RETURNING * [OK]

Quick Trick: Use RETURNING * after DELETE FROM to get deleted rows [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free