單項(xiàng)選擇題
哪條語句將按照字母順序返回EMP表中每個部門的員工姓名列表(以逗號分隔)()
A.SELECTdeptno,LISTAGG(ename,",")WITHINGROUPASemployee_listFROMempGROUPBYdeptno
B.SELECTdeptno,LISTAGG(ename,",")WITHINGROUPASemployee_listFROMempGROUPBYdeptnoORDERBYename
C.SELECTdeptno,LISTAGG(ename,",")WITHINGROUP(GROUPBYdeptno)ASemployee_listFROMempORDERBYename
D.SELECTdeptno,LISTAGG(ename,",")WITHINGROUP(ORDERBYename)ASemployee_listFROMempGROUPBYdeptno