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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.