HomeНаука и техникаRelated VideosMore From: Kishan Mashru

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : DELETE DUPLICATE RECORDS FROM A TABLE(3 ways)

52 ratings | 3777 views
This video tutorial demonstrates about how we can delete duplicate records from a table, the video shows 3 different ways to delete duplicate record from a table, one using Group by, second one by using correlated joins and third on by using rownum analytical function You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/21
Html code for embedding videos on your blog
Text Comments (12)
Harish S (1 month ago)
Volume too low
Tanuja Tharapatti (6 months ago)
good......but when using rownumber what if i have more than 2 duplicate records.
pawan kumar (10 months ago)
nice explanation bro but i have a doubt now we have a 5 times inserted each row in a table in that time how can we delete and i have one more quire please let me know bro i need to delete 20 lakh records in a master table how can we delete
raja G (1 year ago)
Thanks for the video Kishan :) your explanations are clear and easy to understand.. keep going..
Sean Tennessee (17 days ago)
Great explanation. There are multiple ways to do this but it’s a good practice to consider performance when dealing with large and wide tables. I am using your series of videos to catch up on my SQL skills. Greetings from America 😀
Kishan Mashru (1 year ago)
Thanks man!!!
Vilas Gaikwad (1 year ago)
please make videos on performance tuning
Raj Vizag (1 year ago)
Awesome Explanation Guys!!!! Keep Going. Good Luck!! Try to make video on Performance Tuning .
ramesh maddheshiya (1 year ago)
Excellent video ....Volume of the video again very low...
Naveen Karigar (1 year ago)
Your voice is not audible.
valli muthaiyah (1 year ago)
very useful video Kishan.. thanks a lot.. looking forward for more videos on interview questions 😊
Kishan Mashru (1 year ago)
I am glad that you enjoyed it!!! Hope, you have liked the video and subscribed to our channel for latest updates :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.