i have table in snowflake and with couple of duplicate records. For examle lets say i have table customer with column firname lastname and age

Here i can find a duplicate records by firstname lastname and age using row number. but when i apply delete dml it doesnt work in snowflake

any way to delete one of the fully duplicates record from table in snowflake

thanks in advance

I tried using row number function to find those duplicate and getting unique numbers in order participation by all of the columns