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 vote92 views1 answer
Download mysql database to excel in android studio
SQL
2 votes92 views1 answer
Oracle run_duration average
SQL
0 vote116 views1 answer
Gcloud sql instance list
SQL
1 vote111 views1 answer
How to use db.execute
SQL
0 vote245 views2 answers
Create fulltext index mysql
SQL
2 votes96 views1 answer
Scaffold npgsql net core
SQL
0 vote102 views1 answer
Find all tables where column name exists oracle
SQL
0 vote100 views1 answer
How to find sql server installation folder
SQL
0 vote110 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
10 votes97 views4 answers
Sql pagination
SQL