listagg oracle code example
Example: oracle sql listagg
SELECT
job_title,
LISTAGG(
first_name,
','
) WITHIN GROUP(
ORDER BY
first_name
) AS employees
FROM
employees
GROUP BY
job_title
ORDER BY
job_title;