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 vote200 views1 answer
Select distinct after join
SQL
1 vote292 views1 answer
Oracle see column type
SQL
0 vote194 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
11 votes195 views6 answers
Distinct sql
SQL
12 votes184 views3 answers
Duplicate a column in sql
SQL
0 vote283 views1 answer
SQL check if record exist
SQL
0 vote185 views1 answer
Enable full text search mysql
SQL
0 vote198 views1 answer
Mysql server not running
SQL
0 vote175 views1 answer
Mysql database is not starting in xampp
SQL
0 vote213 views1 answer
How to import pymysql through jupyter notebook for windows
SQL