[Solved] Which of the following is the correct syntax to use JSON_AGG in a query? — Ans: SELECT JSON_AGG(column_name) FROM table_name; | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Which of the following is the correct syntax to use JSON_AGG in a query?

ASELECT JSON_AGG(column_name) table_name;

BSELECT JSON_AGG FROM table_name WHERE column_name;

CSELECT JSON_AGG(column_name) WHERE table_name;

DSELECT JSON_AGG(column_name) FROM table_name;

Step-by-Step Solution

Solution:

Step 1: Review correct SQL aggregate function syntax
Aggregate functions like JSON_AGG require parentheses around the column and a FROM clause specifying the table.
Step 2: Check each option for syntax correctness
SELECT JSON_AGG(column_name) FROM table_name; uses correct syntax: SELECT JSON_AGG(column_name) FROM table_name; Others miss FROM or parentheses or have misplaced WHERE.
Final Answer:
SELECT JSON_AGG(column_name) FROM table_name; -> Option D
Quick Check:
Correct aggregate syntax = SELECT JSON_AGG(column_name) FROM table_name; [OK]

Quick Trick: Aggregate functions need parentheses and FROM clause [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to use JSON_AGG in a query?