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 <[EMAIL PROTECTED]> 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] -- -----------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/
