Finding Duplicate Rows Using ROW_NUMBER() | Essential SQL

Here is a really easy way, using a window function, to find duplicate rows within a result. By using the ROW_NUMBER function we'll identify one or more duplicates within a partition, or that is, the columns we are checking for duplicates.

[@youngreezey8253]

Really well explained and easy to understand. Keep making more of this - you absolutely earned my sub :)

[@EssentialSQL]

Awesome, thank you!

[@nadirafant6428]

This is the video I needed!

[@EssentialSQL]

I’m glad you found it!

[@Akkiteja1011]

Out of all the videos I have searched on this topic..this video is best

[@EssentialSQL]

Hi! Thanks for the kind remarks. I appreciate it!

[@mubaraq8853]

Thank you so much for this, very well explained!

[@EssentialSQL]

Glad it was helpful!

[@jrbrey4113]

this was very helpful!

[@EssentialSQL]

I'm glad you found it useful!

[@balrajvirdee1087]

Great explanation thanks so much, this has really helped 👍🏽

[@EssentialSQL]

Glad it helped!

[@brianmurphy6309]

subbed!!

[@nicolposthumus4243]

Very Helpful , Thanks

[@EssentialSQL]

Thanks! I'm glad you liked it!

[@darrylw99]

How can you delete the duplicates when the permanent table won't have a unique column like riw number?

[@memberman]

That's for this helped out

[@EssentialSQL]

Glad it helped - have a great day!

[@RandyWatson80]

you made it click for me, thanks

[@EssentialSQL]

Thats awesome! Let me know if there are other topics you want to hear about.

[@SQLUniversity]

Great Video Essential SQL. Which editor are you writing your SQL in?

[@EssentialSQL]

I'm using Azure Data Studio. It's cross platform.

[@Peterstevoli]

Great video

[@EssentialSQL]

Thanks for the visit

[@samuelmaiia]

Hi there.
How would you do if you want to find duplicate rows in a table with over 30 columns?
Thank you 😊

[@EssentialSQL]

You can either add all 30 columns to your Partition By clause, or figure out what columns really matter and just include those.

[@alexandremondaini]

what is this software that you are using to query databases ?

[@bryannsi]

Azure Data Studio

[@EssentialSQL]

I'm using Azure Data Studio. It my goto SQL tool now. :)

[@chinmayk2657]

How to update one record from duplicate (all value are same)

[@EssentialSQL]

When you use row_number you can elects how to pick the duplicate. So you can update the “first row” or via some other means.
That’s what makes window functions so flexible.
I go over this in my course.

[@payyavulagopichand9809]

how to delete duplicate records using row_number in SQL