gimana kalo ini : select * from table_karyawan where tgl_reumber in (select max(tgl_reumber) from tabel_karyawan group by no_id)
FAJAR SIDIK <[EMAIL PROTECTED]> wrote: kalau mas hidayat query nya menghasil nya max record dari table tsb, yang saya maksud nya query max dari setiap karyawan. krn dalam field tsb karyawan bisa 2x atau 3x reumbers dengan jenis reumbers yang sama, contoh medical, gigi atau kacamata ... jadi hasil recordnya : contoh : no_id tgl reumbers reumbers nama 017 06-sep-06 medical f ajar 017 09-sep--06 gigi fajar 017 15-sep-06 kacamata fajar kenapa hasil nya bisa 3 records ? krn di dalam field reumbers, fajar melakukan beberapa kali medical, gigi dan kacamata maka hasil nya 3 records. pertanyaannya adalah, gimana hanya mengambil tgl_reumbers terbesar yaitu tgl 15-sep-06 aja yaitu kacamata ? Solichul HADI menulis: Untuk mengetahui data dari field no_id, tgl_reumber,reumbers,nama berdasarkan nilai reumbers terbesar : select no_id, tgl_reumber,reumbers,nama where reumbers in (select Max(distinct reumbers) from table_name) FAJAR SIDIK wrote: Guys, Help me plsss , gw punya table karyawan : dengan field : no_id, tgl_reumber,reumbers,nama keterangan : di field reumber,isinya : medical, -- direumber 2x setahun kacamata, -- dapat reumber 2x setahun gigi, -- direumber 2x setahun nah gimana kita kalau mau cari max yang direumber karyawan, krn kalau gw pake " select max(tgl_reumbers), no_id,reumbers, nama from karyawan group by no_id,reumbers, nama ; " maka yang keluar adalah semua isi field(semua jenis) dengan max tgl transaksi nya, padahal kita mau cari hanya yang max transaksi apapun jenis nya ... help me ya plss thks be 4 ... --------------------------------- Apakah Anda Yahoo!? Kunjungi halaman depan Yahoo! Indonesia yang baru! [Non-text portions of this message have been removed] -- -----------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 --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1ยข/min. [Non-text portions of this message have been removed] --------------------------------- Apakah Anda Yahoo!? Kunjungi halaman depan Yahoo! Indonesia yang baru! [Non-text portions of this message have been removed] -- -----------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 --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. [Non-text portions of this message have been removed] -- -----------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/
