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;

Source: oracletutorial.com

Similar codes

1 vote308 views1 answer
Sql comment header
SQL
0 vote287 views1 answer
'0000-00-00' for column '
SQL
0 vote345 views1 answer
How to install postgresql on wsl
SQL
3 votes355 views1 answer
Sql case update
SQL
0 vote335 views4 answers
How to connect form to database
SQL
4 votes315 views1 answer
SQL order random
SQL
2 votes359 views2 answers
Calculate percentage in sql
SQL
1 vote325 views1 answer
Oracle index partition
SQL
0 vote374 views1 answer
Oracle sql developer closed connection
SQL
0 vote289 views8 answers
Convert sql query to linq online
SQL