HomeНаука и техникаRelated VideosMore From: Joey Blue

Delete Duplicates in SQL - SQL Training Online

266 ratings | 28305 views
http://www.sqltrainingonline.com 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 2012 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 http://www.sqltrainingonline.com/how-to-remove-duplicate-rows-in-sql-server/. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Html code for embedding videos on your blog
Text Comments (34)
Robert Dietrich (3 months ago)
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
Mohammad Kashkooly (3 months ago)
Good job Joey
coolandtall (5 months ago)
Good video. Thanks
Vikas Dangwal (9 months ago)
Fadi Shammo (1 year ago)
Excellent Job
Ross Bown (1 year ago)
Life saver.
Richard Cooper (1 year ago)
Excellent video thanks!! :-)
catsarereallycool (2 years ago)
Subhomay Ghosh (2 years ago)
Life saving
Jeff Jones (2 years ago)
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?
No answer, huh, hmmm.
Afif Khaja (2 years ago)
Very superb explanation. Thank you!
Joshua Akwo (2 years ago)
This is BRILLIANT!! Thanks!!
Kamlesh Nakade (2 years ago)
Thanks..Nice Explanation :)
Elio Rivas (3 years ago)
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
ahpitre (3 years ago)
Are there any performance advantages between the 2 methods (which one is faster)? Also, which method uses less system resources (CPU, RAM, etc.)?
Phillippe jean (3 years ago)
Saddam Samahon (3 years ago)
mr (3 years ago)
Very nice!  Subscribing now!
Saravanan S (3 years ago)
pavlo01 (4 years ago)
M Subramaniyam Reddy (4 years ago)
This was very simple and Real Helpful, thanks a lot Joey, Request you to keep posting some more tricks.
darshan s (4 years ago)
good one joey...
Dimitar Filipov (4 years ago)
Thank you so much!
Pawan Gupta (4 years ago)
Thanks a lot Joey! Really enjoyed. Thank you one again.
cpolos (5 years ago)
Thanks Joey, I used the first trick to correct duplicate data into my data warehouse.
siva kumar (5 years ago)
Thank you very much joey for your help i understood it well.
Arif Dawood (5 years ago)
Very good
gagandeep kaur (5 years ago)
Thanks a lot , i was always confused with this query :-)
Aniket Waghavkar (5 years ago)
Maja aali re lekka haa video baghun
Siri Subbu (5 years ago)
Thanks Joey ..You made it very simple for beginners like me... super like !
Ashok Konanki (5 years ago)
nice one joey
Kirti sardana (5 years ago)
Most common question in sql server interviews ...good one Joey !
WXYNQZBM TT (5 years ago)
This is just what I need. Thank you so much!!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.