Archives of the TeradataForum
Message Posted: Wed, 05 May 2004 @ 20:12:46 GMT
one question - are the rows idententical in all columns - which means is it a multiset table?
You might try the following - I can't verfiy currently on my own:
delete from big_table where (field list,row_id) in (select field list,row_id from big_table group by field list qualify csum(1,field list) > 1 ) ;
I am not sure if it is row_id or rowid..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|