Ternyata memang "banyak jalan menuju Roma", silakan Mas Herry cari jalan yg effisien ... dan perlu di explain plan dulu nih ...
Bw, --- In [email protected], "Ane Oracle" <[EMAIL PROTECTED]> wrote: > > select Id, nama, date, keterangan > from A, > (select Id, max(date) date from A) B > where a.id = b.id and a.date = b.date > > On 2/13/07, 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] <indo-oracle% 40yahoogroups.com> [mailto: > > [email protected] <indo-oracle%40yahoogroups.com>] > > On Behalf Of Herry Yusirwan > > Sent: Tuesday, February 13, 2007 11:36 AM > > To: [email protected] <indo-oracle%40yahoogroups.com> > > 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] > > > > > > > > > > -- > ----- > Fight back spam! Download the Blue Frog. > http://www.bluesecurity.com/register/s?user=YXEubGluZGE1NDkx > > > [Non-text portions of this message have been removed] >
