|
Archives of the TeradataForumMessage Posted: Wed, 28 Oct 2009 @ 19:45:03 GMT
What is the best query that would delete duplicate rows from a MULTISET table? 0) Backup the table. 1) Create clone of your table (without data) 2) INSERT INTO 3) DELETE FROM 4) INSERT INTO 5) DROP whichever table is remaining depending on which approach you took in step 4. 6) Backup the newly cleansed table.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||