SELECT deptno, LIST_AGG(ename) AS EMP_STRING FROM emp GROUP BY deptno;

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

Question Posted / gj

Answer Posted / gj

SELECT deptno, LIST_AGG(ename) AS EMP_STRING
FROM emp
GROUP BY deptno;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are keys in sql?

1004

What is the most important ddl statements in sql are?

997

What is mutating sql table?

1116

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

1073

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1055

Do ddl statements need commit?

974

What are sql constraints?

1180

Do we need to rebuild index after truncate?

1036

How long it takes to learn pl sql?

1015

What is primary key and foreign key?

963

Explain the uses of control file.

1050

Explain what is table in a database?

1062

What is trigger and types?

1030

What are schema-level triggers?

1104

Can you join views in sql?

960