How To Delete Duplicate Rows In a Table | SQL

No video

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

Рет қаралды 25,781

Күн бұрын

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/joingroup...
⭐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

Пікірлер: 36

@vishalsonawane.8905 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

Yeah sure. Thank you so much for watching

@ShivamSingh-hk5pn 2 жыл бұрын

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 2 жыл бұрын

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

@anoopsharma5112 3 жыл бұрын

Good work mate♥️

@CodeEra2020 3 жыл бұрын

Thank you so much.

@ShravanKumar-me6iy 2 жыл бұрын

Saloni ur super in teaching skills

@CodeEra2020 2 жыл бұрын

Thank you so much😊.

@ayushmahajan1969 3 жыл бұрын

Very helpful 👌👌

@CodeEra2020 3 жыл бұрын

Thank you so much for watching

@sriramch3128 2 жыл бұрын

First method getting error

@sourabhgupta190 3 жыл бұрын

Thankyou for making video on that topic 😊

@CodeEra2020 3 жыл бұрын

You are welcome.

@MAMAKIJAANGUGU Жыл бұрын

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

@rishabhrishu1602 3 жыл бұрын

thanqq ma'am please make some video on interview question

@electricalsir Жыл бұрын

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

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

@BHARATHEEYUDU. 2 жыл бұрын

we can use distinct keyword

@Rajashekar01 5 ай бұрын

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

@nishkarshjain5684 3 жыл бұрын

Thanks a lot... ❤️

@CodeEra2020 3 жыл бұрын

You are welcome. Thank you for watching.

@saikiranarani1993 2 жыл бұрын

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

@saikiranarani1993 2 жыл бұрын

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

@KIRANYADAV-kx7wu 11 ай бұрын

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

@sambebhanuchandar562 2 жыл бұрын

Nice explanation mam

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

@sidharthmandal9957 2 жыл бұрын

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

@user-ej4yz3mb6u 9 ай бұрын

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

@copyrightfreemusicss 4 ай бұрын

it is not working in sql.

@manishmishra6245 2 жыл бұрын

What if dept is also same

@surajkumar-tt8yd 2 жыл бұрын

Make complete sql in one video

@Sandeeptez 2 жыл бұрын

Saloni star

@Himanshubhadauria-f8w Жыл бұрын

Not possible select*,count (*)