This shows you the differences between two versions of the page.
— |
kurs:listagg [2022/03/14 14:04] (current) admin created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | select | ||
+ | department_id, | ||
+ | listagg(last_name, '; ') within group (order by employee_id) emp_list | ||
+ | from hr.employees | ||
+ | group by department_id; | ||
+ | </code> | ||