I have a common question, but didn't find a simple solution online. How do I remove duplicated rows from delta table? I'm using azure databricks and reading an external delta table stored on azure storage account

Most languages have a distinct method

okay, are you saying create a view that's as select distinct?

Views don't delete anything