[Solved] What does the STRING_AGG function do in PostgreSQL? — Ans: It combines multiple text values into one string with a separator. | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

What does the STRING_AGG function do in PostgreSQL?

AIt combines multiple text values into one string with a separator.

BIt counts the number of rows in a table.

CIt sorts rows based on a column.

DIt deletes duplicate rows from a table.

Step-by-Step Solution

Solution:

Step 1: Understand STRING_AGG purpose
STRING_AGG is used to join multiple text values into a single string with a separator.
Step 2: Compare with other options
Counting rows, sorting, or deleting duplicates are different functions, not STRING_AGG.
Final Answer:
It combines multiple text values into one string with a separator. -> Option A
Quick Check:
STRING_AGG joins text values = It combines multiple text values into one string with a separator. [OK]

Quick Trick: Remember: STRING_AGG joins strings with a separator [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does the STRING_AGG function do in PostgreSQL?