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 vote177 views3 answers
Mysql CAST(amount as float)
SQL
1 vote137 views2 answers
Install mysqldump ubuntu
SQL
10 votes147 views4 answers
Mysql one week ago
SQL
15 votes140 views4 answers
Mysql where value is null
SQL
0 vote143 views1 answer
Mysql date format unix timestamp
SQL
4 votes143 views2 answers
Show all database inside postgresql
SQL
0 vote147 views1 answer
Sql get guid
SQL
0 vote137 views4 answers
First max salary in sql
SQL
0 vote149 views1 answer
Top 3 salary in sql
SQL
0 vote135 views1 answer
User defined variables in sql
SQL