remove row level duplicate in a single statement

General
Enthusiast

remove row level duplicate in a single statement

Hi,

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.