Delete Duplicates in SQL - SQL Training Online - Quick Tips Ep43

Delete Duplicates in SQL Server - SQL Training Online
In this video, I show you two different techniques to remove duplicate records in a SQL Server table.
I don't use the SQL distinct operators, but I actually group the data and apply unique row identifiers to make the SQL delete easier.
Both of the SQL delete statements involve SQL Server CTE statements and use the Row_Number operator to assist in the process. With the operator, you can identify the duplicate rows
You can get the sample script to run the test yourself at www.sqltrainingonline.com/how-....
If you enjoy the video, please give it a like, comment, or subscribe to my channel.
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
www.sqltrainingonline.com/how-...
UA-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ua-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

[@robertdietrich7488]

Hi Joey, I do SQL for my job but I can always learn and you are by far one of the best youtubers I've come across to explain certain aspects of SQL. Thanks Bobby D

[@msubramaniyamreddy4096]

This was very simple and Real Helpful, thanks a lot Joey, Request you to keep posting some more tricks.

[@sardanakirti]

Most common question in sql server interviews ...good one Joey !

[@jazzmiller2690]

This was an amazing no nonsense and extremely well explained video, you saved me hours Thank you Joey !

[@uniqueperls]

Thanks a lot Joey! Really enjoyed. Thank you one again.

[@wxynqzbmtt4164]

This is just what I need. Thank you so much!!

[@sirisubbu8162]

Thanks Joey ..You made it very simple for beginners like me...
super like !

[@cpolos]

Thanks Joey, I used the first trick to correct duplicate data into my data warehouse.

[@joshuaakwo2022]

This is BRILLIANT!! Thanks!!

[@lochinc.1885]

Thank you Joey, I have learnt a lot from your videos here and Udemy.

[@afifkhaja]

Very superb explanation. Thank you!

[@sivakumar-cs4ji]

Thank you very much joey for your help i understood it well.

[@luisvalerin9559]

Hi thanks, that's exactly what I needed.

[@kamleshnakade2277]

Thanks..Nice Explanation :)

[@RichardCooperrjc]

Excellent video thanks!! :-)

[@TewariTwins]

Thanks a lot , i was always confused with this query :-)

[@mohammadkashkooly1987]

Good job Joey

[@catsarereallycool]

Excellent!

[@fadimichael9788]

Excellent Job

[@Tall-Cool-Drink]

Good video.
Thanks

[@ashokkonanki5650]

nice one joey

[@dergimorka6126]

thank you very much bro u did my job for me

[@darshanmot]

good one joey...

[@bgstreetchamp]

Thank you so much!

[@saddamsamahon3881]

GOOD JOB

[@mmr7517]

thank you

[@saravanansomasundaram1902]

superb.............

[@dicerice1]

Very nice! Subscribing now!

[@arifdawood]

Very good

[@ripross2117]

Life saver.

[@pavlo01]

Thanks

[@subhomayghosh2138]

Life saving

[@nari10a1]

awesome

[@vikasdangwal3080]

Nice

[@lochinc.1885]

Do you have advanced sql video lessons as well?

[@jeffjones9299]

Mr. Blue, thank you for this wonderful tutorial. I do have a question though. lets say you have semi-duplicate data they both hold the same information, except on may have an extra field or 2 with additional data, how can you combine the two and remove that as a duplicate?

[@adrienneanderson-smith2257]

No answer, huh, hmmm.

[@aniket137]

Maja aali re lekka haa video baghun

[@ArpanPatre]

Muddam Marathi madhey lihlas na
Tycha khutaak pan kelh tyla smjhla pan nhi🤣🤣🤣

[@ahpitre]

Are there any performance advantages between the 2 methods (which one is faster)?
Also, which method uses less system resources (CPU, RAM, etc.)?

[@PibioxD]

hey bro, i have a table called pacgold and colums `_url`, `_position`, `empresa`, `objetivo`, `ubicacion`, `email`, `numero`, `website` how can i do it? i'm using phpmyadmin

[@jameciamoore5212]

Not sure if this works anymore. Is this half code?

[@badguy66626]

errors in every line

[@BinhLe-wg3ym]

Parttion by