SELECT CASE WHEN KOLOM3 IS NULL THEN WHEN KOLOM2 IS NULL THEN KOLOM1 ELSE KOLOM2 END AS AMOUNT FROM TABEL
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua Jackson Sent: Tuesday, September 05, 2006 6:18 PM To: [email protected] Subject: [indo-oracle] select menggunakan case expression Dear all, Saya ingin mengambil data dari tiga kolom dalam satu tabel yang sama namun melibatkan case expression. kolomnya sbb: kolom1 | kolom2 | kolom3 logikanya adalah: Kalau kolom3 kosong maka amount = kolom2 kalau kolom2 kosong maka amount = kolom1 Row dalam kolom1 tidak pernah kosong Saya coba dengan query sbb namun tidak berhasil: SELECT CASE WHEN KOLOM3 IS NULL THEN KOLOM2 WHEN KOLOM2 IS NULL THEN KOLOM1 ELSE KOLOM1 END AS AMOUNT FROM TABEL namun tidak berhasil seperti yang saya harapkan. Ada yang pernah mengalami kasus seperti ini? Masukannya sangat membantu saya. Terima kasih [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/WktRrD/lOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
