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 is the difference between local variables and global variables?

1125

How show all rows in sql?

1016

What is the purpose of cursors in pl/sql?

1138

Why do we need cursor in pl sql?

1138

What is difference between inner join and self join?

1088

What is the order of sql select?

1041

What is the maximum database size for sql express?

1030

What are different categories of sql commands?

1134

What does pl sql developer do?

935

What is program debugging?

1257

What is nvl?

1066

Is sql a backend language?

1100

What is java sql driver?

1129

What does joining a thread mean?

1023

What is the best sql course?

988