[Solved] What is the result of this query?SELECT letter FROM (VALUES ('A'), ('B'), ('C')) AS t(letter) WHERE letter = 'B'; | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

What is the result of this query?

SELECT letter FROM (VALUES ('A'), ('B'), ('C')) AS t(letter) WHERE letter = 'B';

AA

BB

CC

DNo rows

Step-by-Step Solution

Solution:

Step 1: Identify the inline data and alias
The VALUES clause creates rows with letters 'A', 'B', and 'C' aliased as letter.
Step 2: Apply the WHERE condition letter = 'B'
Only the row with letter 'B' matches and is returned.
Final Answer:
B -> Option B
Quick Check:
WHERE letter = 'B' returns B only [OK]

Quick Trick: Filter inline rows by column alias in WHERE [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the result of this query?