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 is the use of nvl function?

1124

how to decrement dates by 1 in mysql? : Sql dba

968

How many types of indexes are there in sql?

933

how can we know the number of days between two given dates using mysql? : Sql dba

991

How to call shell script from pl sql procedure?

1175

What is audit logout in sql profiler?

977

What is sql engine in oracle?

927

What are the parts of a basic sql query?

918

what is schema? : Sql dba

986

Explain mutating table error.

1130

What is normalization? How many normalization forms are there?

1010

Why do we use function in pl sql?

1006

What is attribute indicator in pl sql?

959

How many types of index are there?

958

What is scalar and vector?

936