Maksudnya gimana yah? apa yg anda inginkan mencari data yang max(tgl_reumber) aja? Kalau ya, diubah begini gimana select * from karyawan where tgl_reumber = (select max(tgl_reumber) from karyawan)
Maaf kalu salah tangkap. Samsun ----- Original Message ---- From: FAJAR SIDIK <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, September 26, 2006 11:14:32 AM Subject: [indo-oracle] Query Max Record Transaction 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 -- -----------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/
