SELECT deptno, LIST_AGG(ename) AS EMP_STRING FROM emp GROUP BY deptno;

how to get enames with comma seperated values by deptwise
on emp table?

Question Posted / gj

Answer Posted / gj

SELECT deptno, LIST_AGG(ename) AS EMP_STRING
FROM emp
GROUP BY deptno;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define commit?

1053

What is the difference between sum and count in sql?

1039

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1133

What are the advantages of sql?

1100

Is sql a backend language?

1146

What is query optimization in sql?

1043

Why do we use sql constraints?

1215

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

How does a self join work?

1237

What is dialect in sql?

987

What operating systems are supported by oracle sql developer?

1016

What is self-join and what is the requirement of self-join?

1192

What is union and union all keyword in sql?

1112

What is varchar data type in sql?

1140

define data blocks ? : Sql dba

1048