[Solved] Which separator is used in the following query?SELECT STRING_AGG(name, '; ') FROM employees; — Ans: Semicolon and space ("; ") | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Which separator is used in the following query?
SELECT STRING_AGG(name, '; ') FROM employees;

ASemicolon and space ("; ")

BComma (",")

CSpace only (" ")

DNo separator

Step-by-Step Solution

Solution:

Step 1: Identify the separator argument in STRING_AGG
The second argument in STRING_AGG is the separator string; here it is '; ' (semicolon and space).
Step 2: Match the separator to options
Semicolon and space ("; ") exactly matches the separator '; ' used in the query.
Final Answer:
Semicolon and space ("; ") -> Option A
Quick Check:
Separator argument = '; ' [OK]

Quick Trick: Second argument in STRING_AGG is the separator [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which separator is used in the following query?