Alternatif lain: select id, nama, date, ket from a a1 where exists ( select 'x' from a a2 where a1.id = a2.id having max(a2.date) = a1.date ) order by id;
Semoga membantu. Salam, Indra Armansyah [EMAIL PROTECTED] ----- Original Message ----- From: Herry Yusirwan To: [email protected] Sent: Tuesday, February 13, 2007 11:36 AM 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] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.0.411 / Virus Database: 268.17.37/682 - Release Date: 2/12/2007 [Non-text portions of this message have been removed]
