AWS Redshift and Azure Synapse-Removing Duplicate Rows - Hands On Demo!
In this video, I compare techniques used in SQL Server (not Synapse) for removing duplicates to those used in Redshift. Unfortunately, in this area, I find Redshift lacking in flexibility when a table does not have a primary key. I also refer to my video on this subject that was for SQL Server.
( / greg-c-coopman-b07b54103 )
It can be found at the following link:
• Deleting Duplicate Rows Using the Row_Numb... (Deleting Duplicate Rows Using the Row_Number() Windows Function.)