Delete duplicate Rows in SQL
Вставка
- Опубліковано 21 вер 2024
- In this video we have discussed how to delete duplicate rows in SQL using different techniques.
Please like & share the video.
LinkedIn: www.linkedin.com/in/biplabparida
Subscribe our Channel to keep watching intresting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
SQL JOINS : • SQL Joins With Example...
SUB QUERY : • Subquery in SQL || SQL...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Biplaba bhai gote blog kara sethire resource add kara help full haba.
I have seen your all oracle video, its very helpful
thank you sir
very helpful
Special🎉
superb explanation.....!
Thank you 🙂
Finished watching
what about in MYSQL?
Hi Biplab there is no table in Description. Please provide.
I have one question when u are deleting the records all the duplicate gets deletes all 3 , if we dont want to delete all the records but want to keep the 1st record and delete the next 2 which is duplicate how can we ?
Please execute the query you will get your answer
@@CodingGlitz Thanks a lot Sir , Got it
helpful
Glad it helped
Could you please start shell scripting tutorials?
Count (0) what is output?
ua-cam.com/video/UeqMX5jEC5I/v-deo.html
Go through the concept of count. It will be clear.
Sir Duplicate table name so confuse us
Sorry didn't get you
agar ID bhi duplicate ho to isko kaise krna he
delete
Using rowid
Microsoft SQL me kaise karna he pls bata do dimag kharab ho Gaya videos dhoondh ke