Makacih Mas Wawan ... aku dapet masukan baru. Bw ;-)
--- In [email protected], "wawan mulyawan" <[EMAIL PROTECTED]> wrote: > > Select Id, nama, date, keterangan from a where (id, date) in (select id, > max(date) from a group by id) > > > > > -----Original Message----- > From: [email protected] [mailto:indo- [EMAIL PROTECTED] > On Behalf Of Herry Yusirwan > Sent: Tuesday, February 13, 2007 11:36 AM > To: [email protected] > Subject: [indo-oracle] minta tolong query... > > Dear All, > > Saya mempunyai table A dengan data seperti dibawah: > > Id nama date keterangan > > 1 xls 1 jan 07 sekali > > 2 doc 1 feb 07 sekali > > 3 ppt 1 mar 07 sekali > > 1 doc 1 apr 07 dua kali > > 2 doc 1 may 07 dua kali > > 3 ppt 1 jun 07 dua kali > > 4 vsd 25 jun 07 sekali > > 2 xls 02 jul 07 tiga kali > > Bagaimana selectnya untuk mengeluarkan data seperti dibawah (setiap id > dengan tanggal terakhir): > > 1 doc 1 apr 07 dua kali > > 2 xls 02 jul 07 tiga kali > > 3 ppt 1 jun 07 dua kali > > 4 vsd 25 jun 07 sekali > > __ > > Terima kasih > > Rgds, > > Herry > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] >
