How To Delete Duplicate Rows In a Table | SQL | Interview Preparation

[@vishalsonawane.8905]

Hello Mam,
Please make more videos .. beacuse your videos is very helpful .

[@CodeEra2020]

Yeah sure. Thank you so much for watching

[@ShivamSingh-hk5pn]

You are so pouring compassion on engineering boys... Really ur Heart is filled with humility and gratitude... Which is very rare in modern times... Good saloni ji
Keep it up

[@CodeEra2020]

Thank you so much.

[@ravirajpradhan4720]

I seen your SQL video today, really great point wise concept wise explanation with design and attractive interface , But the one thing that u mention in this video-- "YOU CANT SPECIFY TARGET TABLE" error -- I mean to say little little loop holes also u have taken and whatever the concept u are delivering which is perfect -- really nice -- great teaching -- Keep it up -- really great

[@SrinivasMamidi-g2b]

HI, but here the ids 2 and 5 which occur multiple times(2 times) deleted, But actually we need to keep the 2 and 5 ids aswel , delete only the 2nd time occuring data , means i need all the IDs data ( 1 to 9 ids)

[@KIRANYADAV-kx7wu]

executed first query using group by and having clouse but deleted all the duplicate rows not single/distinct record remain in table

[@MAMAKIJAANGUGU]

Only self join one worked for me. Somehow Im not able to select id or * from the table

[@ShravanKumar-me6iy]

Saloni ur super in teaching skills

[@CodeEra2020]

Thank you so much😊.

[@anoopsharma5112]

Good work mate♥️

[@CodeEra2020]

Thank you so much.

[@saikiranarani1993]

please upload video to delete duplicates using CTE and Rank Functions pls excellent convey of knowledge being non IT i understood sooper

[@saikiranarani1993]

please upload soon very very important

[@simranjeetsingh4101]

With CTE as (select row-number ( ) over (partition by email order by I'd )as rn fr employee _info )
Delete from CTE where rn>1

[@rishabhrishu1602]

thanqq ma'am please make some video on interview question

[@sourabhgupta190]

Thankyou for making video on that topic 😊

[@CodeEra2020]

You are welcome.

[@sriramch3128]

First method getting error

[@allauddinmomin8814]

Madam can you write a query that "how to delete duplicates by rank function" and i'm searching everywhere but i didn't get the answer😒

[@electricalsir]

Thank you ma'am it's very useful to us 💖🤠

[@BHARATHEEYUDU.]

we can use distinct keyword

[@Rajashekar01]

JUST PLEASE CLATIFY THE SAME SQL QUERY TRIED ORACLE ITS NOT WORKED LET ME KNOW

[@ayushmahajan1969]

Very helpful 👌👌

[@CodeEra2020]

Thank you so much for watching

[@sidharthmandal9957]

What if the ID’s are also the same?
in that case your query fails i guess ??

[@AsifShaikh-p7g]

I am getting below error
Error: near "E1": syntax error

[@nishkarshjain5684]

Thanks a lot... ❤️

[@CodeEra2020]

You are welcome. Thank you for watching.

[@manishmishra6245]

What if dept is also same

[@sambebhanuchandar562]

Nice explanation mam

[@copyrightfreemusicss]

it is not working in sql.

[@surajkumar-tt8yd]

Make complete sql in one video

[@Sandeeptez]

Saloni star

[@Himanshubhadauria-f8w]

Not possible select*,count (*)