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...
    --------------------------------------------------------------------------------------------
    --------------------------------------------------------------------------------------------

КОМЕНТАРІ • 22

  • @BishoyiFy
    @BishoyiFy 8 місяців тому +2

    Biplaba bhai gote blog kara sethire resource add kara help full haba.

  • @rupalisingh1921
    @rupalisingh1921 7 місяців тому

    I have seen your all oracle video, its very helpful
    thank you sir

  • @archana-no6yf
    @archana-no6yf 4 місяці тому

    very helpful

  • @Rabbani_World_Flock
    @Rabbani_World_Flock 2 місяці тому

    Special🎉

  • @pranayrawat1
    @pranayrawat1 8 місяців тому

    superb explanation.....!

  • @sandipansarkar9211
    @sandipansarkar9211 8 місяців тому

    Finished watching

  • @JyothishWarriar-rg8lk
    @JyothishWarriar-rg8lk 4 місяці тому +1

    what about in MYSQL?

  • @narayanjena4259
    @narayanjena4259 4 місяці тому

    Hi Biplab there is no table in Description. Please provide.

  • @saniyasaleem6434
    @saniyasaleem6434 4 місяці тому +1

    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 ?

    • @CodingGlitz
      @CodingGlitz  4 місяці тому +1

      Please execute the query you will get your answer

    • @saniyasaleem6434
      @saniyasaleem6434 4 місяці тому

      @@CodingGlitz Thanks a lot Sir , Got it

  • @muhammadhadi4549
    @muhammadhadi4549 6 місяців тому

    helpful

  • @anujasawant1655
    @anujasawant1655 7 місяців тому

    Could you please start shell scripting tutorials?

  • @sandyvoice007
    @sandyvoice007 3 місяці тому

    Count (0) what is output?

    • @CodingGlitz
      @CodingGlitz  2 місяці тому

      ua-cam.com/video/UeqMX5jEC5I/v-deo.html
      Go through the concept of count. It will be clear.

  • @pbbhosale9
    @pbbhosale9 3 місяці тому

    Sir Duplicate table name so confuse us

  • @ssbsection7824
    @ssbsection7824 4 місяці тому

    agar ID bhi duplicate ho to isko kaise krna he
    delete

    • @CodingGlitz
      @CodingGlitz  4 місяці тому +1

      Using rowid

    • @ssbsection7824
      @ssbsection7824 4 місяці тому

      Microsoft SQL me kaise karna he pls bata do dimag kharab ho Gaya videos dhoondh ke