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

If you want to know how we can delete duplicate records in few minutes with easy steps. So check out the video now. I hope this video helps you.
Please Like , share and subscribe.
✅Using GROUP BY and HAVING Clause - 01:20
✅Using Self Join- 04:35
Join our Telegram Channel - t.me/joingroupCodeEra
⭐How To Find Duplicate Rows In a Table
• How To Find Duplicate ...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Find Nth Highest Salary in SQL | 5 Different Ways
• Find Nth Highest Salar...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Find the number of Employees working in each department | SQL
• Find the number of Emp...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )
• Aggregate Functions In...
⭐Difference Between DELETE, DROP and TRUNCATE
• Difference Between DEL...
⭐SQL vs NoSQL | MySQL vs MongoDB
• Difference between SQL...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Normalization in DBMS-
• Normalization and its ...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐Create MySQL Database and Table -
• How to Create Database...
#mysql #oracle #dbms #query #top #sqlserver #database #PlacementPreparation

[@vishalsonawane.8905]

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

[@CodeEra2020]

Yeah sure. Thank you so much for watching

[@electricalsir]

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

[@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.

[@KIRANYADAV-kx7wu]

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

[@user-lh4di9zg3u]

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)

[@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

[@sambebhanuchandar562]

Nice explanation mam

[@rishabhrishu1602]

thanqq ma'am please make some video on interview question

[@sriramch3128]

First method getting error

[@MAMAKIJAANGUGU]

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

[@sourabhgupta190]

Thankyou for making video on that topic 😊

[@CodeEra2020]

You are welcome.

[@sidharthmandal9957]

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

[@anoopsharma5112]

Good work mate♥️

[@CodeEra2020]

Thank you so much.

[@ayushmahajan1969]

Very helpful 👌👌

[@CodeEra2020]

Thank you so much for watching

[@Rajashekar01]

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

[@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😒

[@nishkarshjain5684]

Thanks a lot... ❤️

[@CodeEra2020]

You are welcome. Thank you for watching.

[@BHARATHEEYUDU.]

we can use distinct keyword

[@ShravanKumar-me6iy]

Saloni ur super in teaching skills

[@CodeEra2020]

Thank you so much😊.

[@user-ej4yz3mb6u]

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

[@manishmishra6245]

What if dept is also same

[@copyrightfreemusicss]

it is not working in sql.

[@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

[@surajkumar-tt8yd]

Make complete sql in one video

[@Sandeeptez]

Saloni star

[@khabib29-06]

Not possible select*,count (*)