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 vote129 views1 answer
Check message id sql server
SQL
5 votes127 views1 answer
How to check nls format in oracle
SQL
0 vote125 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote141 views1 answer
How to create a table based on another table in mysql
SQL
0 vote124 views1 answer
Lost connection to mysql
SQL
0 vote153 views2 answers
Mysql add days to date
SQL
5 votes125 views2 answers
Copy data from one database to another
SQL
0 vote160 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote142 views1 answer
Oracle change password expiration policy
SQL
0 vote140 views1 answer
Mysql default tls v1.3 ciphersuites
SQL