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 vote228 views1 answer
Run docker container with database as rds metabase
SQL
8 votes118 views1 answer
Similarities between ddl and dml
SQL
35 votes168 views6 answers
Postgres
SQL
0 vote151 views1 answer
Sqlite select split string
SQL
1 vote165 views1 answer
Sqlite3 read only
SQL
1 vote146 views1 answer
Deleting database in sql
SQL
0 vote212 views1 answer
Having all mysql
SQL
0 vote161 views1 answer
Sql select where more than one record exists
SQL
0 vote290 views1 answer
Mysql delete entire row on condition
SQL
1 vote157 views1 answer
Oracle grant on all tables in schema
SQL