[Solved] Identify the error in this query:SELECT name, (SELECT price FROM products) AS product_price FROM sales; | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

Identify the error in this query:

SELECT name, (SELECT price FROM products) AS product_price FROM sales;

ANo error, query runs fine

BSubquery returns more than one row causing error

CIncorrect table name in subquery

DMissing alias for subquery result

Step-by-Step Solution

Solution:

Step 1: Check subquery result
The subquery selects price from products without filtering, so it returns multiple rows.
Step 2: Understand scalar subquery requirement
Scalar subqueries must return exactly one value; multiple rows cause an error.
Final Answer:
Subquery returns more than one row causing error -> Option B
Quick Check:
Scalar subquery must return single value [OK]

Quick Trick: Scalar subqueries must return exactly one row and one column [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: