Archives of the TeradataForum

Message Posted: Thu, 02 Aug 2012 @ 19:15:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

If "mlset" is multiset table with duplicate rows. Then use the below query to remove duplicates.

SQL:

     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.

Regards,

Krishna

	<Prev	Next>		<<First	<Prev	Next>	Last>>