Interested to Buy Any Domain ? << Click Here >> for more details...
how to get enames with comma seperated values by deptwise
on emp table?
- 8 Answers
- 11891 Views
- I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
SELECT deptno ,
LTRIM(MAX( SYS_CONNECT_BY_PATH (
ename, ',')),',') EMP_STRING
FROM
(SELECT empno , ename, deptno,
row_number() OVER ( PARTITION BY deptno ORDER
BY rownum) rn
FROM EMP )
CONNECT BY deptno = PRIOR deptno
AND rn = PRIOR rn+1
START WITH rn =1
GROUP BY deptno
ORDER BY deptno;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to call a javascript function from pl sql?
Is sql a dbms?
How do I upgrade sql?
What is sql deadlock?
Are stored procedures faster than queries?
Is it possible to create the following trigger: before or after update trigger for each row?
What does where 1/2 mean in sql?
What is the starting oracle error number?
What is optimistic concurrency control? : Transact sql
What is difference between my sql and sql?
What are local and global Indexes and where they are useful.
How do I run a pl sql procedure in sql developer?
What version is sql?
what is the syntax used for partition in tsql? : Transact sql
What is out parameter used for eventhough return statement can also be used in pl/sql?
