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

how to shut down the server with 'mysqladmin'? : Sql dba

990

How many clustered indexes can be created on a table?

1067

How do I start sql from command line?

998

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1128

What is the difference between join and natural join?

914

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1008

What is meant by user defined function?

1026

what is index? : Sql dba

988

What is synchronized subquery?

1140

What are the different operators available in sql?

985

Why is a trigger used?

925

What is primary key sql?

1011

What are different types of queries in sql?

1100

Why do we need pl sql?

955

Name the different types of indexes in sql and define them.

1116