How To Delete Duplicate Rows In a Table | SQL | Interview Preparation
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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
Hello Mam,
Please make more videos .. beacuse your videos is very helpful .
Yeah sure. Thank you so much for watching
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
Thank you so much.
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
Saloni ur super in teaching skills
Thank you so much😊.
Thankyou for making video on that topic 😊
You are welcome.
thanqq ma'am please make some video on interview question
Good work mate♥️
Thank you so much.
Very helpful 👌👌
Thank you so much for watching
Only self join one worked for me. Somehow Im not able to select id or * from the table
Thank you ma'am it's very useful to us 💖🤠
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)
we can use distinct keyword
executed first query using group by and having clouse but deleted all the duplicate rows not single/distinct record remain in table
First method getting error
please upload video to delete duplicates using CTE and Rank Functions pls excellent convey of knowledge being non IT i understood sooper
please upload soon very very important
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
JUST PLEASE CLATIFY THE SAME SQL QUERY TRIED ORACLE ITS NOT WORKED LET ME KNOW
Thanks a lot... ❤️
You are welcome. Thank you for watching.
What if the ID’s are also the same?
in that case your query fails i guess ??
Nice explanation mam
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😒
I am getting below error
Error: near "E1": syntax error
it is not working in sql.
What if dept is also same
Make complete sql in one video
Saloni star
Not possible select*,count (*)