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]> 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>, "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> [mailto:
> > > [email protected]
> > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.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>
> > > 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]
