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

✨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)

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

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

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

Simply superb, doing a great job, simple and clear

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

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

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

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

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

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

Excellent, your solutions are just great and easy to understand

This was very helpful! Thank you so much

So helpful thank you for sharing!

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

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

Very detailed description... thanks

Very nice.simple understanding way you explain so nice

Very well explained....Thank you 😀

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

over partition example was really helpful

SUPER HELPFUL!

Learned best way to query thanks for the video !!

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

Nice Explaination. You have a lovely voice

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

Helped me a lot Thanks 😁

Good Job!, Thank you.

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

thanks you explained well...

Clear explanation keep doing more videos👍

well Explained !! Thank you.

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

Your efforts helped me a lot Thankyou mam

Thanks for such stuff🥰

Nice explanation with such a calm voice.

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

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

Thanks for Helping

excellent explanation

Thanks it is very important interview question

Good work, thanks

Perfect. Thanks.

SO SIMPLE AND EASY

very good explanation..

It's really helpful

your videos are awesome please make more videos on different topics

So informative...👍

Very well explained

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

Excelente muchas gracias

Good explanation

Well explained👍

Very good explanation keep it up 👍

Thank you so much

Your contents are amazing

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

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

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

Great videos.

Thank you

Much appreciated

Thank you.

Excellent

Thank u dear..

Thanks

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

Super thank 🌹you

THANKS

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

Superb

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

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?

Very nice

Nyc video sister.

superb...good job...

Thanku

ur voice is so nice😍

Gr8 wrk!

Excellent madam pls do videos on power bi also pls

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

INSERT INTO temp_table SELECT DISTINCT * FROM old_table;

so sNice tutorialt like that

Super

Your English is good

Thumbs up👍🏻

Good

SUPER

The first method ,the same query will it work in Oracle sql

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?

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

Can we use the MAX(ID) method?

Hi..one question i have ..pls rply ASAP... I'm using MYSQL and MYSQL doesn't support select * into.. therefore i used insert into newtable select distinct * from old table ...here i faced one issue...i hv one tble with eid,ename and salary. eid field is PK and ename and salary has duplicate values ...now when i use insert into using distinct keyword it copies duplicate data as well ......i only want distict data to be copied ..i tried dropping PK but on column eid but i'm facing same issue

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.

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

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 ??

where rn>1 is not a good practice use having rn> 1 instead of it. Good video

nice explanations

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?

Jah bless!