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

3 votes120 views1 answer
How to check schema privileges in oracle
SQL
0 vote120 views1 answer
Linebreak sql
SQL
1 vote128 views1 answer
How to select random rows from a table
SQL
5 votes115 views1 answer
JBDC
SQL
18 votes88 views2 answers
How to get all the tables displayed in oracle
SQL
8 votes125 views1 answer
Oracle add datafile to tablespace
SQL
1 vote121 views2 answers
Oracle replace
SQL
0 vote117 views1 answer
How to query all tables mysql at the same time
SQL
0 vote115 views1 answer
Sql developer search all packages for text
SQL
6 votes168 views2 answers
How to get last element sql
SQL