if there are row level duplicate in a multiset table, is there any way to remove those duplicate in singal satement?
i usually do it by either transferring the rows into a similar set table or
use a qualify row_number statement to get the records in a temporary table and then delete all from main table and last step is, insert data from temporary to main.
however,many times i have been asked to do this task in a single sql statement .i don't think it is possible in teradata but i may be wrong.
please let me know.