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 vote109 views1 answer
Rollback to name in sql
SQL
0 vote66 views1 answer
Connection error in mysql workbench
SQL
1 vote66 views1 answer
Denied
SQL
0 vote114 views1 answer
Mysql terminal run sql file
SQL
1 vote107 views1 answer
Mysql sort by date column
SQL
18 votes106 views6 answers
Mysql create table
SQL
0 vote132 views2 answers
Postgres isnull
SQL
0 vote70 views1 answer
Mysql timeout 30 seconds
SQL
0 vote150 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
1 vote97 views1 answer
Drush sql-dump
SQL