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:[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]
