Ashfi,
coba ini semoga membantu
select a.*,
case when Mod(rownum, 2) <> 0
then rownum
else null
end ganjil,
case when Mod(rownum, 2) = 0
then rownum
else null
end genap
from namatable a
salam
supriatna
www.asupna.com
----- Original Message ----
From: abe ashfi <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, May 7, 2008 11:27:33 AM
Subject: [indo-oracle] tanya Query dunk...
Dear Para master Oracle,
Hallo akang2 dan teteh2 master Indo-Oracle. ...
Ak mau tanya Query nich..
Gimana yach query untuk menampilkan 2 kolom,
kolom pertama dari data yg rownum nya ganjil dan kolom ke-2 yg rownum nya genap.
tolong saya dunk..
makasih sebelum dan sesudahnya..
____________ _________ _________ _________ _________ _________ _
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/
;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
