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 vote380 views1 answer
Check database restore status sql script
SQL
0 vote363 views1 answer
Vs 2019 connect to local mysql database
SQL
-1 vote351 views1 answer
Mysql order by on condition
SQL
6 votes292 views2 answers
Generate c# class from sql server table
SQL
1 vote392 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote340 views1 answer
Mysql batch insert
SQL
1 vote341 views3 answers
Postgresql crete view
SQL
1 vote347 views3 answers
Mysql Server Start
SQL
0 vote347 views1 answer
Connect to ssms with python
SQL
0 vote336 views1 answer
Composit key in sql
SQL