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
