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 vote217 views1 answer
Low level operator in dbms
SQL
0 vote226 views1 answer
Kotlin sqlite delete row
SQL
0 vote244 views1 answer
Second Step in installing SQL workbench
SQL
0 vote188 views1 answer
How to connect sql server using ip address in c#
SQL
16 votes231 views6 answers
Insert sql
SQL
0 vote241 views1 answer
Mysql database hyphen
SQL
2 votes240 views2 answers
Change varchar length mysql
SQL
1 vote233 views1 answer
Sql server locks
SQL
11 votes230 views4 answers
Query DISTINCT
SQL
4 votes272 views1 answer
Rename stored procedure in sql server
SQL