how to get enames with comma seperated values by deptwise
on emp table?
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 |
Post New Answer View All Answers
What is number function in sql?
how can we destroy the cookie? : Sql dba
Why do we need sharding?
how to concatenate two character strings? : Sql dba
What is online transaction processing (oltp)?
What is the difference between inner join and outer join?
what are the type of locks ? : Sql dba
How to get unique records from a table?
How do I partition in sql?
How is sql used in oracle?
What are the set operators in sql?
how to return query output in html format? : Sql dba
what is query cache in mysql? : Sql dba
What is the advantage of nosql?
Explain clause in sql?