[Solved] What is the output of this query?SELECT * FROM (VALUES (1, 'Red'), (2, 'Blue')) AS colors(id, name); | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

What is the output of this query?

SELECT * FROM (VALUES (1, 'Red'), (2, 'Blue')) AS colors(id, name);

AOne row with array [(1, 'Red'), (2, 'Blue')]

BSyntax error due to missing table

CEmpty result set

DTwo rows with columns id and name: (1, 'Red') and (2, 'Blue')

Step-by-Step Solution

Solution:

Step 1: Understand VALUES with alias
The VALUES clause creates two rows. The alias 'colors' names the columns as id and name.
Step 2: Result of SELECT * from VALUES
The query returns two rows: first row (1, 'Red'), second row (2, 'Blue'), with columns id and name.
Final Answer:
Two rows with columns id and name: (1, 'Red') and (2, 'Blue') -> Option D
Quick Check:
VALUES + alias = rows with named columns [OK]

Quick Trick: VALUES with alias returns rows with named columns [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the output of this query?