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

0 vote126 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
1 vote132 views1 answer
Rows to comma separated values in mssql
SQL
3 votes143 views1 answer
Get all elements sql
SQL
0 vote139 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote134 views4 answers
Mysql desactivar trigger
SQL
6 votes153 views1 answer
Allsource oracle
SQL
1 vote160 views1 answer
Autocommit mysql
SQL
0 vote141 views1 answer
Describe in sqlite3
SQL
0 vote149 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote148 views1 answer
How to tell if i have lactose intolerance
SQL