how to get enames with comma seperated values by deptwise
on emp table?
Answer Posted / gj
SELECT deptno, LIST_AGG(ename) AS EMP_STRING
FROM emp
GROUP BY deptno;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the working of foreign key?
How does a covering index work?
How can we link a sql database to an existing android app?
how can you create an empty table from an existing table? : Sql dba
How can triggers be used for the table auditing?
What does rownum mean in sql?
What are the different set operators available in sql?
Does execute immediate commit?
what are the disadvantages of mysql? : Sql dba
How do I count rows in sql?
What is a crud api?
Is inner join same as self join?
What is the need of merge statement?
Will truncate release space?
What is a mutating table and a constraining table?