Employee id as column department wise

Question

I need to build a query which will give me employee id as columns. Since there can be any number of employees in a department, the number of columns is decided at runtime. The output should be as below. A,B,C,D etc. are employee id's

DEPT EMP1 EMP2 EMP3 EMP4 ... EMP(n)
===================================
10    A   B    C     D         E(n)
20    P   Q    R     
30    X   Y

Search this site for `oracle+pivot` – APC Jun 27 '17 at 10:30 — APC, Jun 27 '17 at 10:30

score 3 · Answer 1 · answered Jun 27 '17 at 10:37

3

you need read about pivot operator

if number of employees is fixed read this Pivot and Unpivot

if number of emp is dynamic - read this thread Pivot Command, can the IN clause be dynamic rather than hard-coded values?

see this article Dynamic pivot in oracle sql

answered Jun 27 '17 at 10:37

are

2,535
2
22
27

pivot needs a aggregate function. I don't want to aggregate any column but want to show the employee id's as column – PTK Jun 27 '17 at 11:16

Employee id as column department wise

1 Answers1