sql help

[omegamark]

Normally when we select we get records like

empno deptno
34 10
35 10
36 10
37 20
38 20
39 20

i need to get the records like

deptno empno empno empno
10 34 35 36
20 37 38 39


In access we will be able to do this with transform with columns .how about this in oracle in sql statement.

[marist89]

Please, only one thread per topic. http://www.dbasupport.com/forums/sho...threadid=14604