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

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

Question Posted / kavitha nedigunta

Answer Posted / kavitha nedigunta

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

works in 10g

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain two easy sql optimizations.

995

what are the advantages of sql ? : Sql dba

1042

What is sql injection vulnerability?

928

Sql technical questions

1253

what are different types of keys in sql?

1128

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1021

what is myisam? : Sql dba

1055

What do you mean by field in sql?

1069

What is an intersect?

1088

How do you rank data in sql?

983

What are different categories of sql commands?

1115

What is execute immediate?

1068

What is compiled query?

1016

Is sql a backend?

1003

Does sql full backup truncate logs?

1007