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 vote295 views3 answers
Between keyword sql
SQL
1 vote333 views1 answer
Primary key with prefix sql
SQL
11 votes310 views1 answer
Sql query to find duplicates in column
SQL
0 vote320 views1 answer
Sql update subtract value
SQL
-1 vote292 views1 answer
Sql getdate date only
SQL
0 vote320 views1 answer
How to query without duplicate rows in sql
SQL
0 vote316 views1 answer
SQL Server Enterprise
SQL
0 vote299 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote327 views1 answer
Mysql disable triggers
SQL
20 votes312 views1 answer
Sql change column types
SQL