How to delete duplicate rows using Row_Number() in SQL Server

In this video we'll use the Random_Number() window function to delete duplicate rows in SQL Server.

0:00 - Intro
0:37 - What is the Row_Number() function?
1:34 - Demo: Row_Number() in basic form
2:20 - Introducing the PARTITION BY option
5:21 - Demo: Deleting the duplicate rows using the PARTITION BY option
6:28 - Potential downsides
7:02 - Closing Thoughts

Row_Number() Documentation:

[mshezi]

very nice ...im very impress...upload the more videos sir...

[adhilakshmiv]

Post more videos regd SQL. You've great skills, it would be helpful for budding people

[rudroroy]

Hi Dalbir, thank you for sharing your knowledge, I would request you to make more videos on specific in-built functions offered by Microsoft SQL server, I am coming from a MySQL/PostgreSQL background it would be helpful for me and others like me.

[pabloarmario]

Congratularions for the video. As you mentioned at the end of your video, I have a database with millions of rows. What would you recommend me to identify and delete duplicate data. i cant do it using this function.