Querynya kira2 begini : SELECT a.col col_ganjil, b.col col_genap FROM (SELECT ROW_NUMBER() OVER (ORDER BY col) row_num, col FROM ( SELECT ROW_NUMBER() OVER (ORDER BY col) r_num, col FROM tab) WHERE MOD(r_num,2) != 0)a, (SELECT ROW_NUMBER() OVER (ORDER BY col) row_num, col FROM ( SELECT ROW_NUMBER() OVER (ORDER BY col) r_num, col FROM tab) WHERE MOD(r_num,2) = 0)b WHERE a.row_num = b.row_num (+);
hth, AH abe ashfi wrote: > > > 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.. > >
