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]
