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 embedded sql with example?

985

What is the difference between in and between in sql?

994

How do I create a sql script?

1050

Is t sql a programming language?

1005

What is a full join sql?

981

What is a parameter query?

1020

Are subqueries better than joins?

917

Can we perform dml on view?

975

What are instead of triggers?

993

what is the use of friend function? : Sql dba

971

Which is faster truncate or drop?

981

What are the different datatypes available in PL/SQL?

1027

How to fetch alternate records from a table?

1158

How to get list of all tables from a database?

1107

What is $$ in sql?

940