Thursday, October 23, 2003

Source: Geekswithblogs.net Main Feed Simple way to Remove Duplicate Rows from an Existing Table in SQL SELECT DISTINCT * INTO duplicate_table FROM original_table GROUP BY key_value HAVING COUNT(key_value) > 1 DELETE original_table WHERE key_value IN (SELECT key_value FROM duplicate_table) INSERT original_table SELECT * FROM duplicate_table DROP TABLE duplicate_table [Geekswithblogs.net Main Feed] 9:41:12 AM    trackback []     Articulate []