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

Are stored procedures faster than queries?

522

Is inner join same as self join?

578

What program will open a mdb file?

494

Explain 3 basic parts of a trigger.

831

What is a primary key? Explain

538

Write a sql query to get the third highest salary of an employee from employee_table?

633

How many types of triggers exist in pl/sql?

561

Is oracle sql free?

536

What is the difference between syntax error and runtime error?

612

What is percent sign in sql?

713

How to run sql*plus commands in sql developer?

589

Explain how exception handling is done in advance pl/sql?

550

How does cross join work in sql?

533

What are different categories of sql commands?

632

What is procedure and function?

515