SELECT DEPT.DEPT_ID,LIST_AGG(E.EMP_NAME) FROM EMP E,DEPT D WHERE E.DEPT

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

Question Posted / g

Answer Posted / g

SELECT DEPT.DEPT_ID,LIST_AGG(E.EMP_NAME) FROM EMP E,DEPT D WHERE E.DEPT_ID=DEPT.DEPT_ID GROUP BY DEPT.DEPT_ID;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What pl/sql package consists of?

1060

How to pipe multiline string to isql?

998

what are set operators in sql? : Sql dba

1023

What is a crud api?

940

What is a join?

1047

Is sql easier than java?

991

Does user triggers have entry for trigger with compilation errors?

1019

what are different types of collation sensitivity? : Sql dba

1057

Is pl sql a programming language?

965

what are local and global variables and their differences? : Sql dba

1055

explain the difference between delete , truncate and drop commands? : Sql dba

1074

What is dml with example?

1066

Differentiate between % rowtype and type record.

1278

Can you have more than one key in a database?

919

How to assign sql query results to pl sql variables?

1050