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 vote176 views1 answer
Postgres where
SQL
12 votes191 views5 answers
Rename table in mysql
SQL
5 votes164 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote172 views1 answer
Mysql select all table that have field names
SQL
0 vote171 views1 answer
List column names of multiple tables psql
SQL
-1 vote200 views1 answer
Select first rows postgresql
SQL
0 vote176 views1 answer
Contraint default SQL
SQL
5 votes170 views1 answer
Sql first day of current year
SQL
0 vote182 views1 answer
Sql clear table
SQL
3 votes194 views4 answers
Ubuntu stop mysql
SQL