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 vote258 views1 answer
Oracle synonym procedure dblink
SQL
0 vote282 views1 answer
Tinydb add table
SQL
0 vote279 views1 answer
Lost connection to mysql
SQL
0 vote267 views1 answer
Psql datestyle
SQL
0 vote264 views1 answer
Sql alter table order by
SQL
0 vote280 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote267 views1 answer
Allow external access to mysql
SQL
5 votes282 views1 answer
Invalid column name sql
SQL
0 vote243 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote263 views1 answer
Groupby error in mysql
SQL