tambahin.... select z.* from ( Select nama, 'R' RL, ukuranR from table where RL = 'R' union all Select nama, 'L' RL, ukuranL from table where RL = 'L' ) z order by 1,2,3
Salam, Laurens "sofyan bahri" <[EMAIL PROTECTED]> Sent by: [email protected] 10/21/2008 03:40 PM Please respond to [email protected] To <[email protected]> cc Subject RE: [indo-oracle] SQL Merubah Kolom Menjadi Baris pakai ini aja Select nama, 'R' RL, ukuranR from table union all Select nama, 'L' RL, ukuranL from table salam Sofyan B -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 21, 2008 3:08 PM To: [email protected] Subject: [indo-oracle] SQL Merubah Kolom Menjadi Baris Dear All.. Ada yg bisa bantu SQL untuk Merubah Kolom Menjadi Baris Contohnya : Nama UkuranR UkuranL -------- ------------- ------------ Rina 50 60 Menjadi Nama RL Ukuran Rina R 50 Rina L 60 Sebelumnya terimakasih ya atas bantuannya..... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
