Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 15:35:10 GMT

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

Hello Mr. Kumar,

Thanks for the fast response.

Your approach will delete complete table.

Hello All Again,

Let me repeat my question with the example.

     /DDL/
     Table :-CREATE MULTISET TABLE test
          (
           A VARCHAR(20) CHARACTER SET UNICODE NOT CASESPECIFIC,
           B VARCHAR(20) CHARACTER SET UNICODE NOT CASESPECIFIC,
           C DECIMAL(17,0))
     PRIMARY INDEX ( A );


     /INSERT/
     insert into test values('TESTA','TESTB',2000);
     insert into test values('TESTA','TESTB',2000);
     insert into test values('TESTA','TESTB',2000);
     insert into test values('TESTA','TESTB',2000);

     insert into test values('TESTA','TESTB',3000);

     insert into test values('TESTA','TESTB',1000):
     insert into test values('TESTA','TESTB',1000);

     insert into test values('TESTA','TESTB',5000);

     /DELETE LOGIC /

I need an approach which will delete duplicate rows i.e. finally I will have 4 rows in my table.

I don't want to create another table for this activity.

     /Select * from test/

     insert into test values('TESTA','TESTB',2000);
     insert into test values('TESTA','TESTB',3000);
     insert into test values('TESTA','TESTB',1000);
     insert into test values('TESTA','TESTB',5000);

Thanks in advanced.

Best Regards

Surendra Sharma

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