resolve this sql query urgent

[DineshGa]

hi all,
i'm having the table like
[code=oracle]

table: emp
------------------------------

empno ename deptno
--------- ----------- ---------
101 aaa 10
102 sss 10
103 www 10
104 hhhh 20
105 hhhhh 20
106 uuuu 30
107 rrrrrr 30

i have to display the data by writing the query in sql like

deptno empno1 empno2 empno3 empno4
---------- -------- ------------ ---------- -----------
10 101 102 103
20 104 105
30 106 107
[/code]

plz send me to solve this problem

thanks in advance
Dinesh

[amitpatel66]

Please post what you have tried so far??