How to convert many row data to columns?
Posted: Tue Sep 25, 2007 4:22 am
Hi,
I need some help on how to do this:
I've got a data set:
The goal is to have 1 row only per Deptno
Result set should look like:
Any Ideas?
Thanks
I need some help on how to do this:
I've got a data set:
Code: Select all
Deptno Ename
10 MILLER
20 FORD
10 KING
30 JAMES
10 CLARK
20 ADAMS
Result set should look like:
Code: Select all
Deptno Ename1 Ename2 Ename3
10 MILLER KING CLARK
20 FORD ADAMS
30 JAMES
Thanks