makasih koreksinya memang harus pake group by yg bener seharusnya
select Id, nama, date, keterangan from A, (select Id, max(date) date from A group by Id) B where a.id = b.id and a.date = b.date :) Linda On 2/13/07, enike nikawati <[EMAIL PROTECTED]> wrote: > > klo menggunakan max() bukankan harus menggunakan > group by??? > > select b.id, b.nama, b.date1, a.keterangan > from A, > (select id, nama, max(date) date1 > from A > group by id, > nama) b > > where a.id||a.nama||a.date = b.id||b.nama||b.date1 > Thanks, > ikhe > > On 2/13/07, Yulius Wibowo <[EMAIL PROTECTED]<yulius_wibowo%40yahoo.com>> > wrote: > > > > Ternyata memang "banyak jalan menuju Roma", > > silakan Mas Herry cari jalan yg effisien ... > > dan perlu di explain plan dulu nih ... > > > > Bw, > > > > --- In [email protected] > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>, "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><indo-oracle%40yahoogroups.com><indo-oracle% > > 40yahoogroups.com> [mailto: > > > > [email protected] > > > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com><indo-oracle%40yahoogr > oups.com>] > > > > On Behalf Of Herry Yusirwan > > > > Sent: Tuesday, February 13, 2007 11:36 AM > > > > To: [email protected] > > > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com><indo-oracle%40yahoogr > oups.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] > > > > > > > > > > > [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]
