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 vote128 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote123 views1 answer
How to print mysql query of codeigniter query builder
SQL
5 votes143 views4 answers
Start postgres server
SQL
-1 vote131 views3 answers
My sql alter table
SQL
0 vote97 views1 answer
Sql injection mitigation
SQL
7 votes121 views1 answer
Mysql remote connection command line
SQL
14 votes135 views1 answer
Excel is not a database
SQL
2 votes122 views1 answer
Plsql left() function
SQL
0 vote126 views1 answer
Price-colour
SQL
0 vote125 views1 answer
Sql server alter table add column tinyint
SQL