[Solved] Consider the table orders with rows: (101, 'Pen'), (102, 'Pencil'), (103, 'Eraser')What is the result of:SELECT STRING_AGG(product, '|') FROM orders;? | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Consider the table orders with rows:
(101, 'Pen'), (102, 'Pencil'), (103, 'Eraser')
What is the result of:
SELECT STRING_AGG(product, '|') FROM orders;?

A"Pen, Pencil, Eraser"

B"Pen|Pencil|Eraser"

C"PenPencilEraser"

D"Pen| Pencil| Eraser"

Step-by-Step Solution

Solution:

Step 1: Identify separator used
The separator is '|', so strings will be joined with this character without spaces.
Step 2: Join product names with separator
Result is "Pen|Pencil|Eraser" exactly as "Pen|Pencil|Eraser".
Final Answer:
"Pen|Pencil|Eraser" -> Option B
Quick Check:
Separator '|' joins strings exactly [OK]

Quick Trick: Separator is literal string between quotes [OK]

Common Mistakes:

Adding spaces not in separator
Confusing separator with comma

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Consider the table orders with rows:

Step 1: Identify separator used

Step 2: Join product names with separator

Final Answer:

Quick Check:

Want More Practice?