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

how many triggers are allowed in mysql table? : Sql dba

1069

What is plpgsql language?

1063

What is the basic form of sql query?

943

What is cascade in sql?

961

What is the requirement of self-join?

1129

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

Explain the savepoint statement.

1096

What is the use of sqldataadapter?

975

What are secondary keys?

971

What are the types of dbms?

973

What are the different parts of a package?

1115

Is primary key a clustered index?

966

Can we use rowid as primary key?

987

What is difference between hql and sql?

1077

how to enter numeric values as hex numbers? : Sql dba

1064