Delete Duplicates in SQL - SQL Training Online - Quick Tips Ep43
ฝัง
- เผยแพร่เมื่อ 27 ก.ค. 2024
- 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-...
TH-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
th-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 - วิทยาศาสตร์และเทคโนโลยี
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
This was very simple and Real Helpful, thanks a lot Joey, Request you to keep posting some more tricks.
Most common question in sql server interviews ...good one Joey !
Thanks a lot Joey! Really enjoyed. Thank you one again.
Thanks Joey, I used the first trick to correct duplicate data into my data warehouse.
This was an amazing no nonsense and extremely well explained video, you saved me hours Thank you Joey !
Thank you Joey, I have learnt a lot from your videos here and Udemy.
This is just what I need. Thank you so much!!
Thanks Joey ..You made it very simple for beginners like me...
super like !
Very superb explanation. Thank you!
This is BRILLIANT!! Thanks!!
Thank you very much joey for your help i understood it well.
Hi thanks, that's exactly what I needed.
Thanks a lot , i was always confused with this query :-)
Thanks..Nice Explanation :)
Good job Joey
Excellent Job
Excellent video thanks!! :-)
Good video.
Thanks
thank you very much bro u did my job for me
Excellent!
Thank you so much!
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.
Do you have advanced sql video lessons as well?
good one joey...
nice one joey
superb.............
GOOD JOB
Thanks
thank you
Not sure if this works anymore. Is this half code?
Very good
Are there any performance advantages between the 2 methods (which one is faster)?
Also, which method uses less system resources (CPU, RAM, etc.)?
Very nice! Subscribing now!
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
Life saving
awesome
Life saver.
Nice
Maja aali re lekka haa video baghun
Muddam Marathi madhey lihlas na
Tycha khutaak pan kelh tyla smjhla pan nhi🤣🤣🤣
errors in every line
Parttion by