2 Ways to FIND and DELETE Duplicate Rows in a SQL Table | LeetCode SQL

Подписаться 110 тыс.

Просмотров 2,3 тыс.

50% 1

Learn how to find and delete duplicate records in an SQL table efficiently. In this video, I will show you two methods: the beginner's approach and the efficient approach. The beginner's approach is simple, but it's not the most efficient. The efficient approach is more complex, but it's faster and more scalable. I will also show you how to use LeetCode's SQL interview question 196 to practice your SQL skills.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: Coming Soon
Must WATCH
► How To FIND DUPLICATE Records In A SQL Table (Fast and Easy!) • How To FIND DUPLICATE ...
-------------------------------------------------------------------------
►►►Social Media - Where I sort of Live
/ rebellionrider
/ therebellionrider
/ rebellionrider
/ mannbhardwaj
-------------------------------------------------------------------------
►►►Books I refer to
PL/SQL amzn.to/2QE1jX0
Performance Tuning amzn.to/2sgiAw4
1z0-071 Exam amzn.to/2sgfeJw
Python Programming amzn.to/305UEbh
-------------------------------------------------------------------------
►►►Camera Gears
► Video Gears That We Use For Creating Our RU-vid Video
www.amazon.in/shop/manishshar...
► Work From Home Essential Tech That We Use Daily
www.amazon.in/shop/manishshar...
AFFILIATE DISCLOSURE:
Some of the links used in the description will direct you to Amazon.in. As an Amazon Associate, I earn from qualifying purchases at no additional cost to you.
#RebellionRider

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@Rebellionrider 9 месяцев назад

How To FIND DUPLICATE Records In A SQL Table (Fast and Easy!) ru-vid.comkMTxEOYJBrE

@sbalaji92 3 месяца назад

How about using rowid to delete the duplicates as your using Oracle db? Won't that be much more efficient as compared to large datasets?

@teklehaimanotatikilt1435 6 месяцев назад

your videos are awesome can you please upload oracle rac videos?

@ankitsaxena565 7 месяцев назад

Can I use row_number for large data

@user-ps1tw3yb5n 7 месяцев назад

Thanks Sir, could you please make video sessions to explain topic Normalization and it’s forms.

@Rebellionrider 7 месяцев назад

Ok you need a video explaining Normalization, right?

@muzzakkirtamboli7382 7 месяцев назад

Yes

@sandeepbangeramahabala3630 9 месяцев назад

Hello deleting million of records using delete not in it will definetly take huge time. What is correct approach other than this.

@muzzakkirtamboli7382 7 месяцев назад

Either truncate the table else you can partition your table based on your requirements and then drop the partition

@marish_yojo7772 9 месяцев назад

You could have done it with the help of rowid. It's easy to write and efficient

@Rebellionrider 8 месяцев назад

Definitely I could have done that but I wanted this tutorial accessible for most of the available database options but with rowid it will not be possible because many database doesn’t have this function available into them.

@Rebellionrider 8 месяцев назад

By the way did you try this query?

@marish_yojo7772 8 месяцев назад

@@Rebellionrider i haven't tried with this query yet sir, I am thinking this query is not going to help me. Let me write my requirement: We have a table called students with Id,name,class columns. Id colum is having duplicates.we need to delete the records with that distinct of id column. [Note: there is no unique value in other coulm as well] Pls provide your suggestions sir

@user-ps1tw3yb5n 7 месяцев назад

Thanks Sir, could you please make video sessions to explain topic Normalization and it’s forms.