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

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

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

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

Not possible select*,count (*)

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

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)

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

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

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😒

Saloni star

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

What if dept is also same

Mam this is my table.

+-------+---------+--------+
| empid | empname | eadd |
+-------+---------+--------+
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 1 | deepak | Indore |
| 2 | vikas | Bhopal


delete from details
where empid IN
(select empid from
(select *, count(*) as duplicate
from details
group by empid having duplicate>1)
as temp) ;

After executing above query wrong getting output.
Like this : i want two records but it deleting whole recors
those row have same value not remaining single row.

+-------+---------+--------+
| empid | empname | eadd |
+-------+---------+--------+
| 2 | vikas | Bhopal |
+-------+---------+--------+


please resolve it.

Saloni ur super in teaching skills

First method getting error

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

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

Nice explanation mam

we can use distinct keyword

Make complete sql in one video

Thanks a lot... ❤️

thanqq ma'am please make some video on interview question

Thankyou for making video on that topic 😊

Good work mate♥️

Very helpful 👌👌