maaf mau coba select baris, max(col1), max(col2) from (select floor((rownum + 1) / 2) baris, decode(mod(rownum, 2), 0, colom_ambil) col1, decode(mod(rownum, 2), 1, colom_ambil) col2 from table_ambil) group by baris
moga-moga bermanfaat ----- Original Message ----- From: abe ashfi To: [email protected] Sent: Wednesday, May 07, 2008 11:27 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=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
