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
What is the difference between delete, truncate and drop command?
What are hotfixes and patches?
How to create a menu in sqlplus or pl/sql?
Are subqueries better than joins?
What is not in sql?
How to add new employee details in an employee_details table with the following details
What is the most restrictive isolation level? : Transact sql
Do we need to create index on primary key?
how to use case expression? : Sql dba
What will you get by the cursor attribute sql%notfound?
What is a nested table in word?
What is online transaction processing (oltp)?
How can you know that statistics should be updated?
What is procedure explain with example?
what are tables and fields? : Sql dba