DELETE DUPLICATE ROWS FROM A TABLE IN SQL || 4 ways

[@crackconcepts]

✨Link to my SQL e-book: imojo.in/rkajq9 ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[@rajkiranboggala9722]

I really appreciate your time and effort in sharing these (even though you are having cold)!! Thank you

[@srinivasprasad7765]

Ya true..👍

[@ravindrabisht7372]

That's called dedication...keep it up dear

[@ShubhamKumar-mf4sg]

Having cold ..hahaha..nailed it bro

[@tubepankajyou]

Such developers actually reach to top positions, appreciate it.

[@karthikd2104]

Seen so many videos in SQL messed up ...this one really understandable with clear explanation!

[@tchelaa6894]

I have been stuck on this since yesterday. Thank you😎

[@umaannamalai3205]

Thank you for the clear explanations! You made the concepts simple to understand. I’m excited for new videos.

[@adapass]

explanation is very clear by writing in paper which is unique in youtube. great job

[@marvinmachitar7229]

Wow! You are so good teacher. Was able to understand it more than other videos with fancy animation.

[@MoodyVideoGraphies]

kitni awesome hai yaar... So well explained... calm and soothing...

[@akashagarwal6390]

Mam it would be great if you can take up topics or concepts which are really important like this though not much frequently asked in interviews and also it is useful for an engineer to know all these as well

[@bhavanikandikondamatam5926]

Hello madam.. I have doubt in using temporary table.. Can insert distinct values in new table Drop the old table Rename new table as old table?

[@giridandi7480]

Very nice.simple understanding way you explain so nice

[@rajattalnikar6167]

Thankyou so much. You've covered all the methods and discussed them in detail.

[@rakeshgopidi4066]

It's a great post Sadia, no matter how many years of experience we have ,it's always a good revision for any one # Additional Reference There are also other ways to restrict the duplicates 1. UNIQUE 2. UNION 3. ROW_NUMBER | RANK () | DENSE_RANK () - Analytical Function 4. INTERSECT 5. MINUS 6. ROWID | ROWID + CORRELATED SUBQUERY 7. GROUP BY

[@saravananbhojan8750]

Learned best way to query thanks for the video !!

[@mastanshaik5479]

Nice & simple way of understanding 👏👏 for new starters in sql ur videos are best .. thank you for ur efforts and time

[@Rjjithin777]

Simply superb, doing a great job, simple and clear

[@akashverma1640]

Thank you very much for you efforts... Must to be known things👌👌

[@mohansaivelagapudi929]

Thanks for Helping

[@hidden590]

First method is easy to understand ...so I will go with the first method

[@FitVisionTV]

First method will overload database performance. Avoid using select *

[@ankiturmaliya7286]

very good explanation..

[@MUSKAN0896]

This was very helpful! Thank you so much

[@naveenshagala3136]

Nice explanation with such a calm voice.

[@crackconcepts]

Thank you 😃

[@deepakaggarwal8624]

Excellent, your solutions are just great and easy to understand

[@aeriesx4727]

Absolutely brilliant explanation... Thank you so much..

[@sushantpawar5635]

शेंबडाचा त्रास होत असताना देखील खूप छान शिकवलंस🙏👍 thank you

[@zafariqbalunknown9786]

Your efforts helped me a lot Thankyou mam

[@swapneelkambe2092]

Good explanation

[@DeepakMeena-kz9bu]

over partition example was really helpful

[@techninja9461]

Excellent Explanation.....This video is really helpful.

[@husler7424]

Watching in 2022, for placements as being CSE student. Thanks a lot, didi. Your explanation is just amazing.

[@mudasar8629]

Thank a lots !!! :) Hope to see more videos from you.

[@nimmikcherian3242]

Very detailed description... thanks

[@oic_Oracle_integration_cloud]

SO SIMPLE AND EASY

[@joshyjohn9636]

Well explained, It will be most useful video in this topic..

[@rajendrarajendra583]

Your explanation is superb. one small request what ever you explained can you explain in sql server . that is very use full to us.

[@maxiejane]

So helpful thank you for sharing!

[@hadireg]

a bit speedy but you're doing a great job!

[@shivyogi806]

You have amazing, simple.way of teaching. God bless you and Thank you very much

[@meditationandrelaxationmus741]

Thanks it is very important interview question

[@richardconnolly4295]

SUPER HELPFUL!

[@maryamfatima5882]

excellent explanation

[@nausheen292]

Very well explained....Thank you 😀

[@umeshgolla2730]

Excellent explaination..

[@crackconcepts]

Thank you!

[@azharuddinluhar9667]

3rd and 4th way will delete duplicate row from result set and not from actual table, now what to do for deleting duplicate rows from actual actual?

[@veerulinganagoudar3456]

It's really helpful

[@boddanapalliavinash6418]

Very good explanation keep it up 👍

[@akash_pal]

well Explained !! Thank you.

[@bro_7079]

kzbin.info/www/bejne/sHKcp2yio7VleKc

[@shwetabudake6144]

Very well explained

[@mangamanasvi5485]

Good Job!, Thank you.

[@CarlosRivera-mp7mm]

Excelente muchas gracias

[@sohailkat8867]

Nice video, and it would be great if you could make a video on types of Analytical Functions in sql, thanks!

[@vivekrahate2564]

Thank u dear..

[@Aryan-ly5ho]

Helped me a lot Thanks 😁

[@Sriramlivz]

Nice Explaination. You have a lovely voice

[@saurabhbenbanshi3460]

thanks you explained well...

[@digitalcode5685]

THANKS

[@ganeshstars1]

your explanation is good. I am watching most of the videios. for me 1 st method is showing error missing expression.

[@AmanKhan-ei4cg]

Thanks for such stuff🥰

[@jaganjayakumar4874]

Clear explanation keep doing more videos👍

[@leesubiramaniyam2704]

Explaining good & may be increase the volume (sound) better good

[@music4u1235]

so sNice tutorialt like that

[@mrf7283]

very good effort and I appreciate your clips. However I have a question; suppose application messed up and gave same ID to two (2) different unique valid name. eg. 5001 to ABC and 5001 to XYZ and we want to keep both that is they should exists in our resultant with 2 unique IDs. Please don't get me wrong I am not trying to trick you, I had this real situation once with thousands of rows and was stuck.

[@MohanGonnabathula]

In that scenario, you need to add ID, name in partition. DELETE FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY ID, NAME ORDER BY ID) AS Rno FROM emp ) AS E WHERE Rno > 1; This query will delete duplicate rows from the "emp" table where duplicates are determined by the combination of "ID" and "NAME" columns, keeping only the first occurrence and removing the rest.

[@shubhamanand1347]

your videos are awesome please make more videos on different topics

[@praveenvadde278]

Good explanation. Can please explain and show by executing in the system.

[@tushardeepsingh4976]

Hii.. Please clear one question in this video ..In CTE inner query ..you have not used * after select keyword ..you have directly written " select row_number()..." .... * aaega na after select ??

[@HardikShah17]

Perfect. Thanks.

[@namratanikam7566]

Well explained👍

[@shubhamchoudhary5461]

So informative...👍

[@qaz_testzaq_test8138]

Good work, thanks

[@ravaliannaldas9320]

Nyc video sister.

[@muraliraj9658]

Thank you.

[@simranjeetsingh4101]

Thanku

[@mrrishiraj88]

Great videos.

[@ybujji]

Thank you so much

[@sathyasathyam6930]

Super thank 🌹you

[@mannu567]

Instead of MIN if we use Max then what will happen? I guess it will also remove duplicate

[@norbycreation1851]

INSERT INTO temp_table SELECT DISTINCT * FROM old_table;

[@rk-ej9ep]

Very nice

[@ankittiwari-pw6nr]

Thanks

[@rosonerri-faithful]

Can we use the MAX(ID) method?

[@Pavankumar71036]

Excellent

[@labheshlalka9666]

Why we can't use direct delete query whose count greater than 1

[@mohammedyousuf1918]

Super

[@ravindrabisht7372]

Your English is good

[@dhineshrajendran2312]

Much appreciated

[@aditiarjun519]

Hello mam, deleting using CTE throws the following error.... "Error Code: 1288. The target table cte of the DELETE is not updatable" how to resolve it?

[@divyasnarayan1803]

Gr8 wrk!

[@dstar2211]

superb...good job...

[@crackconcepts]

Thank you!

[@dreambig1668]

Hi just one suggestion you first way will always not would the solution for routine. N in your second way we have to design table with identify type then you will be able to access

[@yes-pg5dy]

Excellent madam pls do videos on power bi also pls

[@foolchandsonariwal4203]

Madam derived table delete allow nahi karta he only u can use cte to delete duplicate record.

[@MrsBestTube]

Good

[@sukritsen9530]

Hello, I have a question, how to delete duplicate records with no unique key in mysql? Can this be done using the row_number function?

[@chanduch8973]

DELETE K FROM (SELECT *, ROW_NUMBER () OVER (PARTITION BY emp_id ORDER BY emp_id) AS RN FROM MyTable) K WHERE RN>1

[@helmiboubaker2742]

sorry but the third ways not working for me . this the query that i use delete from (select nom, row_number() over(partition by nom order by nom ) as count_num from fourniseurs)as tab where count_num >1; but the select query work fine i wander why is it not working i use workbench mysql :/

[@mobileminimaster3015]

delete from fourniseurs where nom IN (select nom from (select nom,row_number() over(partition by nom) as count_num from fourniseurs) ee where ee.count_num>1 );

[@joshuasamuel5851]

Superb

[@88pianissimo90]

I think row_number( ) works slower ... right? If you have millions of records then this will work slow.

[@shankar8816]

Ek different positive way me le gye aap lecture ko.. Wldone

[@YPTechDATIA]

use insert into newtable select distinct * from oldtable; then delete * from oldtable; now insert into oldtable select * from newtable;

[@saisumanthnagasuri7741]

What happen if there are more than 50 columns with the duplicate records Instead of passing all the columns names to the partition by clause Is there any way to put * . Any thoughts?

[@swapnilsingh8552]

I am using ROW_NUMBER method to delete but it doesn't work...