terima kasih Pak bantuannya.... kenapa saya tidak berpikir menggabungkan 2 kolom yah.. he....3x
saya coba dahulu Pak.. 2009/11/24 Erry Pambudhi <[email protected]> > > > select * from tes3 > where kode||transaksi in > ( > select kode||max(transaksi) from tes3 > group by kode > ) > > semoga membantu > > Erry > > --- Pada Sen, 23/11/09, AnRof Rawnan > <[email protected]<muhammad.ilman%40gmail.com>> > menulis: > > Dari: AnRof Rawnan <[email protected] <muhammad.ilman%40gmail.com>> > Judul: [indo-oracle] Tanya SQL Query ( Row Maximum ) > Kepada: [email protected] <indo-oracle%40yahoogroups.com> > Tanggal: Senin, 23 November, 2009, 10:22 PM > > > > Dear Rekan2, > > saya punya table seperti di bawah ini : > > Kode | Tanggal | Transaksi | > > 1 | 01/01/09 | 20 | > > 1 | 02/01/09 | 10 | > > 1 | 03/01/09 | 30 | > > 2 | 01/01/09 | 30 | > > 2 | 02/01/09 | 20 | > > 3 | 01/01/09 | 20 | > > 3 | 02/01/09 | 40 | > > bagaimana query untuk mendapatkan hasil seperti ini : > > Kode | Tanggal | Transaksi | > > 1 | 03/01/09 | 30 | > > 2 | 01/01/09 | 30 | > > 3 | 02/01/09 | 40 | > > Row yang diambil tiap2 kode adalah transaksi yang terbanyak. > > Terima kasih sebelumnya.. . :):) > > Regards, > > -- > > YM_id : muh_ilman_a > > http://misisawa. blogspot. com > > Selalu bersama teman-teman di Yahoo! Messenger. Tambahkan mereka dari email > atau jaringan sosial Anda sekarang! http://id.messenger.yahoo.com/invite/ > > [Non-text portions of this message have been removed] > > > -- YM_id : muh_ilman_a http://misisawa.blogspot.com [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! 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: [email protected] [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/
