Can we delete duplicate rows using analytical functions? I mean using row_number() or rank or dense_rank() in Sql …