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
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)
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
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)
Good work mate♥️
Thank you so much.
executed first query using group by and having clouse but deleted all the duplicate rows not single/distinct record remain in table
Saloni ur super in teaching skills
Thank you so much😊.
Very helpful 👌👌
Thank you so much for watching
Thankyou for making video on that topic 😊
You are welcome.
thanqq ma'am please make some video on interview question
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 💖🤠
we can use distinct keyword
JUST PLEASE CLATIFY THE SAME SQL QUERY TRIED ORACLE ITS NOT WORKED LET ME KNOW
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
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 ??
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😒
Nice explanation mam
I am getting below error
Error: near "E1": syntax error
First method getting error
What if dept is also same
it is not working in sql.
Make complete sql in one video
Saloni star
Not possible select*,count (*)