Which of the following is the correct syntax to aggregate values into an array using ARRAY_AGG in PostgreSQL?

easy📝 Syntax Q12 of 15

PostgreSQL - Aggregate Functions and GROUP BY

Which of the following is the correct syntax to aggregate values into an array using ARRAY_AGG in PostgreSQL?

ASELECT ARRAY_AGG(column_name) FROM table_name;

BSELECT ARRAY_AGG column_name FROM table_name;

CSELECT ARRAY_AGG(column_name) table_name;

DSELECT ARRAY_AGG(column_name) FROM table_name WHERE;

Step-by-Step Solution

Solution:

Step 1: Recall correct function call syntax
ARRAY_AGG requires parentheses around the column name and a FROM clause.
Step 2: Check each option
SELECT ARRAY_AGG(column_name) FROM table_name; uses correct syntax with parentheses and FROM clause; others miss parentheses or have syntax errors.
Final Answer:
SELECT ARRAY_AGG(column_name) FROM table_name; -> Option A
Quick Check:
Correct ARRAY_AGG syntax uses parentheses and FROM [OK]

Quick Trick: Always use parentheses with ARRAY_AGG(column) [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free