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

1 vote298 views1 answer
Select statement to print longest name
SQL
1 vote304 views1 answer
Oracle db create new schema
SQL
3 votes321 views2 answers
Mysql import gz
SQL
0 vote319 views1 answer
Mysql range of dates overlap
SQL
3 votes340 views2 answers
Order by postgresql
SQL
1 vote352 views2 answers
Full join
SQL
0 vote302 views1 answer
Mysql drop multiple tables at once
SQL
2 votes350 views1 answer
Rails execute sql
SQL
3 votes366 views1 answer
Oracle undo tablespace schema
SQL
0 vote369 views1 answer
Finding leap year in sql
SQL