User Tools

Site Tools


kurs:listagg

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
  
kurs/listagg.txt ยท Last modified: 2022/03/14 14:04 by admin