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

11 votes195 views1 answer
Ddl materialized view
SQL
0 vote196 views1 answer
Sauvegarde complète my sql
SQL
0 vote195 views1 answer
Postgresql interview questions
SQL
0 vote192 views1 answer
Différence entre deux dates sql oracle
SQL
-1 vote207 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
4 votes193 views1 answer
Check database name postgresql
SQL
4 votes188 views3 answers
Sql find second highest salary employee
SQL
0 vote207 views1 answer
Insert into select with group by
SQL
0 vote270 views1 answer
Postgresql conectar
SQL
1 vote189 views1 answer
Not exists mysql
SQL