Saya coba pake Oracle 9i :
---------------------------------------------------------------------------------------------
select employeeno,
max(decode(rn, 1, address)) address1,
max(decode(rn, 2, address)) address2,
max(decode(rn, 3, address)) address3
from (
select employeeno,
address,
row_number() over (partition by empno order by empno) rn
from myaddress )
group by employeeno;
------------------------------------------------------------------------------------------------------
arynur
On 6/27/05, Saukat, Ardisa A BSP-ISM/115 <[EMAIL PROTECTED]> wrote:
> Dear Oracle Expert
>
> Saya mau nanya nih.
>
> Saya punya table kayak gini
>
> employeeno address
> 1 mampang
> 1 simpur
> 1 sudirman
> 2 bintaro
> 2 cilandak
> 3 bekasi
> 4 kerawang
> 5 cikampek
> 5 purwakarta
>
>
> trus saya mau nampilin kayak gini
>
> employeeno address 1 address 2 address 3
> 1 mampang simpur sudirman
> 2 bintaro cilandak
> 3 bekasi
> 4 kerawang
> 5 cikampek purwakarta
>
>
> gimana ya sql querynya.
> mohon pencerahannya
>
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
