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

1 vote195 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote145 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote147 views1 answer
Find all tables where column name exists oracle
SQL
0 vote144 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote163 views1 answer
How to run parallel queries in sql server with entity framework
SQL
6 votes155 views3 answers
Commit in sql
SQL
1 vote147 views1 answer
Show all event schedular on mysql
SQL
0 vote167 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote146 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote141 views1 answer
Mariadb number format
SQL