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 vote164 views1 answer
How to make a select in sql
SQL
0 vote170 views1 answer
Csv to sqlite python
SQL
2 votes177 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote179 views1 answer
Postgres copy command
SQL
0 vote151 views1 answer
Split a string with expression and get the last value of split sql
SQL
2 votes155 views3 answers
Mysql cheat sheet
SQL
3 votes180 views3 answers
Create a view postgres
SQL
-1 vote166 views2 answers
On update cascade
SQL
0 vote183 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote183 views1 answer
Mysql value ends with
SQL