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 vote102 views1 answer
Select all tables linked server sql
SQL
0 vote116 views1 answer
Postgresql in vs any performance
SQL
6 votes118 views2 answers
Sql display max value
SQL
0 vote106 views1 answer
Stored function in sql
SQL
0 vote111 views1 answer
Sqlalchemy query join many to many
SQL
0 vote69 views1 answer
Import csv to mysql
SQL
8 votes117 views1 answer
How to check mysql version in xampp
SQL
7 votes127 views1 answer
Show line number in sql server
SQL
0 vote116 views1 answer
Postgres clear table
SQL
3 votes115 views1 answer
Pl sql escape &
SQL