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 vote235 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote203 views1 answer
Plsql find location of procedure
SQL
0 vote221 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote222 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote205 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote188 views1 answer
Describe in sqlite3
SQL
0 vote203 views1 answer
Mysql count with two joins
SQL
4 votes231 views6 answers
Select sql
SQL
-2 votes206 views1 answer
Mysql not empty
SQL
0 vote212 views1 answer
What is top n result in sql
SQL