coba diakalin aja, pertama select distinct trus pindahkan ke table sementara (kan jadi tidak kembar lagi), trus table asali dihapus, kemudian isi ulang dengan isi table sementara yang sudah gak dobel.
misalnya gini kalo pake ms sql server: select distinct col1,col2 into temporary_table1 from table1 delete table1 insert into table1 (col1,col2) select col1,col2 from temporary_table1 delete temporary_table1 ati2 kalo nyoba ya!, kalo baris ke 3 gak berhasil ya ambil lagi dari temporary_table1 kalo ada banyak konstren ya harus diilangin dulu konstrennya, nnt kan bisa dipasang lagi. semoaga membantu. ----- Original Message ----- From: "William IT" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 7:33 AM Subject: Re: [Delphindo] data kembar > > Siang semuanya. Bagaimana caranya menghapus record/data yang double > dengan > > perintah SQL. > pake DISTINCT > > SELECT DISTINCT NAMA FROM TABELKU > > ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 http://us.click.yahoo.com/sO0ANB/LIdGAA/ySSFAA/i7folB/TM ---------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
