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

Поделиться
HTML-код
  • Опубликовано: 16 дек 2024

Комментарии • 36

  • @vishalsonawane.8905
    @vishalsonawane.8905 3 года назад +5

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

    • @CodeEra2020
      @CodeEra2020  3 года назад

      Yeah sure. Thank you so much for watching

  • @ShivamSingh-hk5pn
    @ShivamSingh-hk5pn 2 года назад +1

    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

  • @ravirajpradhan4720
    @ravirajpradhan4720 Год назад

    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

  • @SrinivasMamidi-g2b
    @SrinivasMamidi-g2b Год назад +1

    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)

  • @anoopsharma5112
    @anoopsharma5112 3 года назад +3

    Good work mate♥️

  • @the_hidden_route
    @the_hidden_route Год назад

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

  • @ShravanKumar-me6iy
    @ShravanKumar-me6iy 2 года назад +1

    Saloni ur super in teaching skills

  • @ayushmahajan1969
    @ayushmahajan1969 3 года назад +3

    Very helpful 👌👌

    • @CodeEra2020
      @CodeEra2020  3 года назад +1

      Thank you so much for watching

  • @sourabhgupta190
    @sourabhgupta190 3 года назад +1

    Thankyou for making video on that topic 😊

  • @rishabhrishu1602
    @rishabhrishu1602 3 года назад +1

    thanqq ma'am please make some video on interview question

  • @MAMAKIJAANGUGU
    @MAMAKIJAANGUGU Год назад

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

  • @NextGen_Tech_Hindi
    @NextGen_Tech_Hindi Год назад

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

  • @Pandimoori_krish
    @Pandimoori_krish 2 года назад +1

    we can use distinct keyword

  • @Rajashekar01
    @Rajashekar01 8 месяцев назад

    JUST PLEASE CLATIFY THE SAME SQL QUERY TRIED ORACLE ITS NOT WORKED LET ME KNOW

  • @saikiranarani1993
    @saikiranarani1993 2 года назад

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

    • @saikiranarani1993
      @saikiranarani1993 2 года назад

      please upload soon very very important

    • @simranjeetsingh4101
      @simranjeetsingh4101 Год назад

      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

  • @nishkarshjain5684
    @nishkarshjain5684 3 года назад +1

    Thanks a lot... ❤️

    • @CodeEra2020
      @CodeEra2020  3 года назад

      You are welcome. Thank you for watching.

  • @sidharthmandal9957
    @sidharthmandal9957 2 года назад

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

  • @allauddinmomin8814
    @allauddinmomin8814 2 года назад

    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😒

  • @sambebhanuchandar562
    @sambebhanuchandar562 2 года назад

    Nice explanation mam

  • @AsifShaikh-p7g
    @AsifShaikh-p7g Год назад

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

  • @sriramch3128
    @sriramch3128 2 года назад +2

    First method getting error

  • @manishmishra6245
    @manishmishra6245 2 года назад

    What if dept is also same

  • @copyrightfreemusicss
    @copyrightfreemusicss 7 месяцев назад

    it is not working in sql.

  • @surajkumar-tt8yd
    @surajkumar-tt8yd 3 года назад

    Make complete sql in one video

  • @Sandeeptez
    @Sandeeptez 2 года назад

    Saloni star

  • @Himanshubhadauria-f8w
    @Himanshubhadauria-f8w Год назад

    Not possible select*,count (*)