OCP 071中文考试题库(cuug内部资料)第60题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询本套题库是OCP考试中的071(中文版)试题,由CUUG整理,如有报考OCP认证意向,可以联系cuug咨询老师。
60、请选择最佳答案。
哪条语句将按照字母顺序返回EMP表中每个部门的员工姓名列表(以逗号分隔) ?
A) SELECT deptno, LISTAGG (ename, ', ') WITHIN GROUP AS employee_list
FROM emp
GROUP BY deptno
ORDER BY ename;
B) SELECT deptno, LISTAGG (ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list
FROM emp
ORDER BY ename;
C) SELECT deptno, LISTAGG(ename, ', ') WITHIN GROUP AS employee_list
FROM emp
GROUP BY deptno;
D) SELECT deptno, LISTAGG (ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list
FROM emp
GROUP BY deptno;
整理:cuug