[Solved] In PostgreSQL, what is the primary function of ARRAY_AGG? — Ans: To collect multiple row values into a single array | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

In PostgreSQL, what is the primary function of ARRAY_AGG?

ATo collect multiple row values into a single array

BTo calculate the average of numeric values

CTo concatenate strings from multiple rows into one string

DTo filter rows based on array contents

Step-by-Step Solution

Solution:

Step 1: Understand ARRAY_AGG
ARRAY_AGG is an aggregate function that collects values from multiple rows into a single array.
Step 2: Differentiate from other functions
It does not perform calculations like average or string concatenation; those are done by AVG or STRING_AGG respectively.
Final Answer:
To collect multiple row values into a single array -> Option A
Quick Check:
ARRAY_AGG aggregates rows into arrays [OK]

Quick Trick: ARRAY_AGG collects rows into arrays, not calculations [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

In PostgreSQL, what is the primary function of ARRAY_AGG?