OCP的071考试难考？以前确实不容易通过，但现在我们对071考试题库进行了收集整理，并给出了答案，已经帮助很多考生顺利通过了071考试。
--------------------------------------------
071题库整理-第62题、choose the best answer:
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
A) SELECT LISTAGG(last_name, '; ') "Emp_list", MIN(hire_date) "Earliest"
FROM employees
WHERE department_id = 30
WITHIN GROUP ORDER BY hire_date;
B) SELECT LISTAGG(last_name, '; ') "EMP_LIST", MIN(hire_date) "Earliest"
FROM employees
WHERE department_id = 30
ORDER BY hire_date;
C) SELECT LISTAGG(last_name, '; ')
WITHIN GROUP (ORDER BY hire_date) "Emp_list", MIN(hire_date) "Earliest"
FROM employees
WHERE department_id = 30;
D) SELECT LISTAGG(last_name)
WITHIN GROUP ORDER BY (hire_date) "Emp_list", MIN(hire_date) "Earliest"
FROM employees
WHERE department_id = 30;
Answer:C
(解析：工作中会用到把查出来的列的值去重合并成一行显示，可以使用 listagg() WITHIN GROUP () 将
多行合并成一行：
）
-----------------------------------------------
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：https://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与
