SELECT LISTAGG(last_name, ‚; ‚) WITHIN GROUP (ORDER BY hire_date, last_name) „Emp_list“, MIN(hire_date) „Earliest“ FROM employees WHERE department_id = 30; Emp_list Earliest ———————————————————— ——— Raphaely; Khoo; Tobias; Baida; Himuro; Colmenares 07-DEC-02