resolve this sql query urgent

DineshGa

hi all,
i'm having the table like

Expand|Select|Wrap|Line Numbers

  
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

plz send me to solve this problem

thanks in advance
Dinesh

amitpatel66

Please post what you have tried so far??

resolve this sql query urgent

re: resolve this sql query urgent

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about