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 vote214 views1 answer
SQL date part only of datetime
SQL
0 vote209 views1 answer
MySQL FIND_IN_SET()
SQL
14 votes211 views4 answers
Online sql compiler
SQL
20 votes203 views5 answers
Mysql reset auto increment to 1
SQL
0 vote192 views4 answers
Sql limit 1 offset 1
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
8 votes188 views2 answers
Phpmyadmin password
SQL
0 vote234 views1 answer
Datagrip go to line
SQL
0 vote200 views1 answer
Oracle dynamic select into
SQL
4 votes167 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL