Which statement will return a comma-separated list of employee names in alphabetical order for each...

Oracle 1z0-071 Question Answer

Which statement will return a comma-separated list of employee names in alphabetical order for each department in the EMP table?

SELECT deptno,LISTAGG(ename, ' , ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno ORDER BY ename;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list FROM emp ORDER BY ename;

SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list FROM emp GROUP BY deptno;

1z0-071 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"