ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
Out of all the videos I have searched on this topic..this video is best
Hi! Thanks for the kind remarks. I appreciate it!
Really well explained and easy to understand. Keep making more of this - you absolutely earned my sub :)
Awesome, thank you!
Great Video Essential SQL. Which editor are you writing your SQL in?
I'm using Azure Data Studio. It's cross platform.
How can you delete the duplicates when the permanent table won't have a unique column like riw number?
This is the video I needed!
I’m glad you found it!
Hi there.How would you do if you want to find duplicate rows in a table with over 30 columns?Thank you 😊
You can either add all 30 columns to your Partition By clause, or figure out what columns really matter and just include those.
Thank you so much for this, very well explained!
Glad it was helpful!
Great explanation thanks so much, this has really helped 👍🏽
Glad it helped!
what is this software that you are using to query databases ?
Azure Data Studio
I'm using Azure Data Studio. It my goto SQL tool now. :)
this was very helpful!
I'm glad you found it useful!
Great video
Thanks for the visit
you made it click for me, thanks
Thats awesome! Let me know if there are other topics you want to hear about.
That's for this helped out
Glad it helped - have a great day!
Very Helpful , Thanks
Thanks! I'm glad you liked it!
How to update one record from duplicate (all value are same)
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.
subbed!!
how to delete duplicate records using row_number in SQL
Out of all the videos I have searched on this topic..this video is best
Hi! Thanks for the kind remarks. I appreciate it!
Really well explained and easy to understand. Keep making more of this - you absolutely earned my sub :)
Awesome, thank you!
Great Video Essential SQL. Which editor are you writing your SQL in?
I'm using Azure Data Studio. It's cross platform.
How can you delete the duplicates when the permanent table won't have a unique column like riw number?
This is the video I needed!
I’m glad you found it!
Hi there.
How would you do if you want to find duplicate rows in a table with over 30 columns?
Thank you 😊
You can either add all 30 columns to your Partition By clause, or figure out what columns really matter and just include those.
Thank you so much for this, very well explained!
Glad it was helpful!
Great explanation thanks so much, this has really helped 👍🏽
Glad it helped!
what is this software that you are using to query databases ?
Azure Data Studio
I'm using Azure Data Studio. It my goto SQL tool now. :)
this was very helpful!
I'm glad you found it useful!
Great video
Thanks for the visit
you made it click for me, thanks
Thats awesome! Let me know if there are other topics you want to hear about.
That's for this helped out
Glad it helped - have a great day!
Very Helpful , Thanks
Thanks! I'm glad you liked it!
How to update one record from duplicate (all value are same)
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.
subbed!!
how to delete duplicate records using row_number in SQL