Archives of the TeradataForum
Message Posted: Thu, 02 Aug 2012 @ 19:15:07 GMT
If "mlset" is multiset table with duplicate rows. Then use the below query to remove duplicates.
create multiset table kris.mlset1 as (sel distinct * from kris.mlset) with data;
Create another table with subquery as distinct * and with data from original multiset table. Drop the original table. No need to user any external load utilities.
Thanks for your time.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|