I want to delete the dulplicate rows from the multiset table. I don't have access to create another table in database. Please help me to delete the duplicate rows from table without using another table.
Try google search for
Delete duplicate rows teradata
And Carlos posted some code here:
This above approach is good but seems a bit complex to me..use the power of Volatile table in this scenario...if you have full row duplicate issue then it will work superbly..see the approach below..
CREATE SET VOLATILE TABLE YOUR_VOLATILE_TABLE AS
) WITH DATA ON COMMIT PRESERVE ROWS
DELETE FROM YOUR_MAIN_TABLE;
INSERT INTO YOUR_MAIN_TABLE
SEL * FROM YOUR_VOLATILE_TABLE;