Pak,mungkin anda bisa menggunakan query ini SELECT TO_CHAR(daftar,'YYYYMM') FROM tbA GROUP BY TO_CHAR(daftar,'YYYYMM') ORDER BY TO_CHAR(daftar,'YYYYMM')
CMIIW Regards, Antonius Bayu ----- Original Message ---- From: AnRof Rawnan <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, March 12, 2008 9:28:30 AM Subject: [indo-oracle] create list month Dear Master, saya mau tanya bagaimana cara bikin query-nya... seandainya saya punya table tbA No | name | daftar 1 | A | 1-jan-08 2 | B | 1-feb-08 3 | C | 1-may-08 4 | D | 1-jun-08 saya ingin tahu daftar urutan bulan2 dari field "daftar" mulai bulan awal hingga bulan akhir. jadi seandainya saya gunakan "select distinct to_char(daftar, yyyymm) from tbA", maka hasilnya bulan maret tidak muncul, bagaimana cara menampilkan. . thx's -- YM_id : muh_ilman_a http://misisawa. blogspot. com http://anrof. myminicity. com/ [Non-text portions of this message have been removed] ____________________________________________________________________________________ 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]
