Dear Andhi, Coba kamu tambahkan 1 field, typedata Integer AutoIncrement. NoUrut Kode Nama Qty 1 A1 AAAAA 10 2 A1 AAAAA 10 3 B1 BBBBB 10 4 B1 BBBBB 10 5 C1 CCCCC 5 6 C1 CCCCC 5
select * from TbData where NoUrut in ( select max(NoUrut) from TbData group by Kode ) Kalo ini sudah tepat, ganti select menjadi delete delete from TbData where NoUrut in ( select max(NoUrut) from TbData group by Kode ) Regards, Yulianto KwetChiro --- In [email protected], Purwedi Kurniawan <[EMAIL PROTECTED]> wrote: > > SELECT DISTINCT kode, nama, qty > INTO namatablebaru > FROM namatablelama > > kalau buat cari data mana aja yg double: > > SELECT kode > FROM namatable > GROUP BY kode > HAVING COUNT(kode) > 1 > > best regards > [wwn] > > On 1/4/06, Andhi Y <[EMAIL PROTECTED]> wrote: > > > > Teman2, > > > > Saya punya tabel, > > > > Kode Nama Qty > > > > A1 AAAAA 10 > > > > A1 AAAAA 10 > > > > B1 BBBBB 10 > > > > B1 BBBBB 10 > > > > C1 CCCCC 5 > > > > C1 CCCCC 5 > > > > > > > > Saya ingin hapus data yang double itu gimana caranya ya? Kalo pake syntax > > SQL bisa gak? Sehingga data yg saya inginkan seperti ini: > > > > Kode Nama Qty > > > > A1 AAAAA 10 > > > > B1 BBBBB 10 > > > > C1 CCCCC 5 > > > > > > > > Thx. > > > Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
