Top SQL interview Questions and Answers | Most Asked SQL Questions for Job interview

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 มี.ค. 2023
  • Top SQL interview Questions and Answers | Most Asked SQL Questions for Job interview
    Want more similar videos- hit like, comment, share and subscribe !
    🔖SQL Interview Q&A PDF: bit.ly/3Zz450w
    👍Subscribe Now: bit.ly/3Fc7Gc6
    👉Instagram: / rishabhnmishra
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    More SQL for data science Videos:
    📢Full SQL Tutorial in One Video: • SQL Tutorial for Begin...
    🔖Most Asked SQL Interview Question: • Most Asked SQL Intervi...
    🔖SQL Tutorial Playlist: • SQL Tutorial In Hindi
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    📣Want to connect with me? Check out these links:📣
    👉Instagram: / rishabhnmishra
    👉LinkedIn: / rishabhnmishra
    👉Twitter: / rishabhnmishra
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    More Related Videos:
    📢Full Excel Tutorial in one Video: • Excel Tutorial For Beg...
    🔖Excel Tutorial Playlist: • Excel for Beginners | ...
    🔖Complete Data Analyst Roadmap: • How to Become Data Ana...
    🔖Data Analyst Roadmap, Skills and Jobs: • Data Analyst- Skills, ...
    🔖What Does a Data Analyst Actually Do?: • What Does a Data Analy...
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    Hope you liked this video and learned something new :)
    See you in next video, until then Bye-Bye!
    #sql #sqlinterviewquestionsandanswers #sqlinterviewquestions
    SQL Interview Questions and Answers
    SQL Interview Questions
    SQL Interview Questions Answers
    Mostly asked SQL Interview Questions Answer
    Commonly asked SQL Interview Questions Answer
    SQL Command Based Interview Questions Answer
    Advanced SQL Interview Questions Answer
    Top 10 SQL Interview Questions Answer
    SQL Interview Questions SQL Interview Questions and answers for Freshers and Experienced
    Top 10 SQL Interview Questions Answer
    SQL Interview Questions Answer
    SQL Interview
    SQL Interview Questions for freshers
    SQL Interview Questions and answers for freshers
    SQL Roadmap
    SQL Interview Questions 2023
    SQL Interview Experience Interview questions for SQL Experienced

ความคิดเห็น • 340

  • @vinayakdevane9688
    @vinayakdevane9688 ปีที่แล้ว +5

    Sir tumhi khup changl shikvta youtube vr best samjel as shikvnare tumhich ahat ❤

  • @vandanaprajapati2316
    @vandanaprajapati2316 ปีที่แล้ว +7

    Very Useful and explained very easily ....Waiting for Part 2 Interview Questions

  • @TataNaresh
    @TataNaresh ปีที่แล้ว +4

    Wow loved the way Rishab teaching SQL concepts enjoyed video.🤩

  • @aryan043
    @aryan043 ปีที่แล้ว +2

    Thanks bro..very helpful.. best of luck for channel.. learning more from you..

  • @shitalthorat-wm6js
    @shitalthorat-wm6js ปีที่แล้ว +2

    Thanks a lot sir.... such valuable information

  • @sudhansubhol6052
    @sudhansubhol6052 ปีที่แล้ว +2

    Thank you sir , really valuable questions for us.
    Please upload a video on Tableau project.

  • @susamay
    @susamay ปีที่แล้ว +4

    Really great channel. Your quality is at it's peak.

  • @gauravbatra982
    @gauravbatra982 ปีที่แล้ว +3

    Sir thank uh so much for providing such a usefull and effective content!! So can uh pls make video on full fledge SQL project!?

  • @ManKR
    @ManKR ปีที่แล้ว +2

    Your Content is always nextLevel
    Thankyou sir.

  • @abhayjaiswal4838
    @abhayjaiswal4838 22 วันที่ผ่านมา +1

    Nicely explained today learnt something new. Thank you Rishabh bhai🙌

  • @RahulMishra-oc7dv
    @RahulMishra-oc7dv ปีที่แล้ว +1

    I think this is easy compare to you for skills>3
    Select candidate_id,count(*) from tablename group by candidate_id having count(*)>2;

  • @riteshgaihre6277
    @riteshgaihre6277 7 หลายเดือนก่อน

    you are very hardworking, genius. you have put lots of efforts to make this videos. I CAN understand. thank you so much

  • @Techno1parth
    @Techno1parth ปีที่แล้ว

    Please more sql queation video share with data .
    Data rah to sath-sath pratice hoti hai .
    your video awsome hai voice video clearity👍. Muzhe bohat help ho rahil hai .

  • @tannubajpai4782
    @tannubajpai4782 ปีที่แล้ว +1

    You contain some special talent for explanation

  • @zahidalam7831
    @zahidalam7831 4 หลายเดือนก่อน

    You explained very well sir I m waiting for another video

  • @sanmitradas986
    @sanmitradas986 7 หลายเดือนก่อน +1

    Rishabh, please upload a detailed video on SQL triggers

  • @shakuntalakumari8460
    @shakuntalakumari8460 ปีที่แล้ว +10

    Hi Rishabh, please suggest some most asked questions in Power Bi & Dax at the intermediate level. U can also share the questions only.

    • @Aditya61515
      @Aditya61515 5 หลายเดือนก่อน +1

      Indian paradise Trainer visit this channel

  • @karishmabhardwaj603
    @karishmabhardwaj603 ปีที่แล้ว +22

    One of My best learning Channel..... Thanks for this video Sir... :)

  • @harshitverma1263
    @harshitverma1263 ปีที่แล้ว +26

    Literally one of the best channel related to data analyst/data science! Waiting for some more tutorials and projects related to this field. Also kindly continue this series on sql interview questions as this is by far the most asked thing in the interview

  • @tusharchaudhary7937
    @tusharchaudhary7937 ปีที่แล้ว

    Keep it up sir 👍 very helpful content 😊

  • @bhavinpadhiyar9829
    @bhavinpadhiyar9829 5 หลายเดือนก่อน

    Thank you for this video, Rishabh!! Congratulations for completing 202K subscribers on this channel...

  • @Ramesh00300
    @Ramesh00300 ปีที่แล้ว +5

    @Rishabh Mishra - in the question no 3, what if there is duplicate entry for skill sql instead of python, I mean for candidate id 101, if there are 3 entries of skills like SQL,POWER BI and SQL. The count will still show 3 but that is not the condition right ? how do we deal with duplicates skill entries ?

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  ปีที่แล้ว +3

      In that case you can take distinct of skills as CTE n rest of the steps will be same n you will get the answer. Btw good question brother ✅️

  • @sushantmeshram5172
    @sushantmeshram5172 หลายเดือนก่อน +1

    thank you so much Rishab

  • @sanketkalevlogs7911
    @sanketkalevlogs7911 ปีที่แล้ว +2

    Please make video on MySQL for data analytics

  • @PatialaKing-up2te
    @PatialaKing-up2te 2 หลายเดือนก่อน

    Thank you sir ❤❤

  • @kingomya45
    @kingomya45 7 หลายเดือนก่อน +2

    Sir best video 📸

  • @AzharWahajIjtaba
    @AzharWahajIjtaba 10 หลายเดือนก่อน +1

    you are the best

  • @lifeisbeautiful1111
    @lifeisbeautiful1111 11 หลายเดือนก่อน

    please make a video on machine learning ,NLP,DL and statistics

  • @deveshpadgelwar8895
    @deveshpadgelwar8895 ปีที่แล้ว +1

    How to find duplicate data without using group by clause and distinct ? Using CTE

  • @nbadya2674
    @nbadya2674 ปีที่แล้ว +1

    thank you

  • @mohinikunwar1621
    @mohinikunwar1621 ปีที่แล้ว +2

    Thanks a lot for such a wonderful sessions… just with 2 videos my most of the sql concepts are making sense now… thanks a lot 🎉🎉 And congratulations for your achievement😍🧿

  • @eshanksharma7616
    @eshanksharma7616 ปีที่แล้ว +2

    Good content

  • @sahil-dogra
    @sahil-dogra 11 หลายเดือนก่อน +4

    I had an interview today and over the client call. they asked me write the query about "find the candidate with these skills" and I was lucky enough that I know this through your channel. Even though query did not work but they got the idea that I know this. I don't know if I will be selected or not but it definitely boost my confidence. Thanks a ton.

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  11 หลายเดือนก่อน

      Excellent! Keep learning n keep growing 🚀

    • @user-wt5rs6jr7u
      @user-wt5rs6jr7u 10 หลายเดือนก่อน

      in which company ? which types question will asked you?

    • @Harshal__Patil
      @Harshal__Patil 10 หลายเดือนก่อน

      Which other questions they asked

  • @roniteraj4201
    @roniteraj4201 ปีที่แล้ว +2

    Sir, thanks for such videos which are very helpful for data aspirants

  • @MdRizwan-uu9dv
    @MdRizwan-uu9dv ปีที่แล้ว +8

    In question no. 11
    As per my understanding we can't use equal operator to compare NULL values because very NULL is different with other one that's why we have IS NULL, NOT NULL.

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  ปีที่แล้ว

      Yeah i think you're right 🤔
      But you can use equals to Operator to update a value in sql.
      UPDATE customers
      SET C_CONTACTNO = NULL
      WHERE C_ID = 4;
      This works!

    • @theraizadatalks14
      @theraizadatalks14 ปีที่แล้ว

      Yes, for comparing Null values we don't use equal operators in sql.
      We always use 'Col_name is Null'

    • @shreyadas4699
      @shreyadas4699 10 หลายเดือนก่อน

      true...we can't use equals to operator for comparing nulls...I got stuck at the same thing watching the video

  • @SAW8149
    @SAW8149 ปีที่แล้ว +1

    Great

  • @beingrishi6450
    @beingrishi6450 ปีที่แล้ว +1

    Awesome

  • @sushantprabhu007
    @sushantprabhu007 2 หลายเดือนก่อน

    Excellent videos Mishra ji. Aise video dekhe nahi kabhi

  • @sid_analytics
    @sid_analytics 3 หลายเดือนก่อน

    Very helpful! Thank you very much. Am literally watching this video one day before my interview

  • @unicorn27-01
    @unicorn27-01 9 วันที่ผ่านมา +1

    please make more videos like this also please make a oneshot video on mysql

  • @MoNiKa-29-RN
    @MoNiKa-29-RN ปีที่แล้ว +2

    all videos are amazing... also u provide a pdf that is very useful.. Thank you so much, sir.

  • @user-wu5zo1th5o
    @user-wu5zo1th5o 6 หลายเดือนก่อน

    Plz prepare vedio- products based company Case study in excel. In one of interview asked for me.

  • @jaikishanthakur3459
    @jaikishanthakur3459 ปีที่แล้ว

    my query is can i write same query again and again in sql because for practicing , many times what happened it shows already object in data base for that i have write again and do some changes. let me confident about commands then not worries in future , but as of now any trick so that do for practice

  • @sagar857
    @sagar857 9 หลายเดือนก่อน +1

    Really enjoying watching your videos, learning a lot , Thanks for doing such a great work for community. God bless you.
    A request - Could you please make a video on SQL server profiler and how to debug Stored Procedure??

  • @HemaSahoo
    @HemaSahoo ปีที่แล้ว +1

    Very well explained. Thanks a ton!!!!

  • @rishav144
    @rishav144 ปีที่แล้ว +7

    best channel for Data Science

  • @mohammedshabaaz9625
    @mohammedshabaaz9625 ปีที่แล้ว +1

    please more more parts of such amazing videos.
    will be helpful

  • @pratoshkumarjha89
    @pratoshkumarjha89 ปีที่แล้ว +5

    Kindly continue this series on Important Questions on SQL

  • @mantoshroy4076
    @mantoshroy4076 ปีที่แล้ว +4

    Keep continue sir 😊🙏
    Great content ❤️😍👌

  • @PankajPandey-vc6vc
    @PankajPandey-vc6vc 11 หลายเดือนก่อน +1

    The way you explain the things its amazing thanks Rishabh

  • @satyastocks3773
    @satyastocks3773 ปีที่แล้ว +1

    One of the best learning channel thank you very much sir

  • @moneshantu3652
    @moneshantu3652 11 หลายเดือนก่อน

    For fresher in data science what questions will be asked by a interviewer for python related maka a video sirr

  • @iloveyourstatus3929
    @iloveyourstatus3929 ปีที่แล้ว +1

    Nice

  • @anshumankumar9342
    @anshumankumar9342 ปีที่แล้ว +8

    Your videos have been very helpful, and it would be great if you could provide more practice SQL questions in future videos. I appreciate the value of your content and find it worth watching

  • @Khansarah
    @Khansarah ปีที่แล้ว +1

    Very informative video in simple way … 👍

  • @YourYTHUB
    @YourYTHUB 11 หลายเดือนก่อน +1

    valuable content brother ...and congratulations brother u marked 120k subs. keep growing

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  11 หลายเดือนก่อน +1

      Glad you liked it ✅️ n thank you so much brother 🙌

  • @dattatrayarathi1014
    @dattatrayarathi1014 9 หลายเดือนก่อน +1

    Thank you so much sir for a sharing video

  • @shubhangidhakane6922
    @shubhangidhakane6922 ปีที่แล้ว +1

    good

  • @hemantpanchal8087
    @hemantpanchal8087 6 หลายเดือนก่อน

    Can someone pls guide me, which database is preferable for core banking domain between mssql and postgresql?
    apart from Oracle.

  • @ujjwalkhandelwal5132
    @ujjwalkhandelwal5132 3 หลายเดือนก่อน +1

    Hello Rishabh bhai, a small correction at 6:47 in Solution MySql: please select 'MONTHNAME' instead of 'MONTH' to get the name of month.
    Keep it up the nice work👍

  • @aasmohammad6332
    @aasmohammad6332 ปีที่แล้ว +1

    Hey hope you doing good I am new here
    I feel you doing fantastic work your way of teaching unbelievable... I requested to you please make vedio on full analysis like how to collect data how to transform, organize data, and how make preidiction and drive informed decisions... And where I need sql and python and pythonlibraries for retrieves and manipulate data

  • @anshulshukla2595
    @anshulshukla2595 2 หลายเดือนก่อน

    Please create a video for Python and Tableau and Power BI interview question-answer

  • @mayurib5667
    @mayurib5667 3 หลายเดือนก่อน +1

    Sir you are explaining very well. Thank you

  • @muhammadmazhar8596
    @muhammadmazhar8596 ปีที่แล้ว +1

    Execellent presentation Respected Sir

  • @anupmishra154
    @anupmishra154 ปีที่แล้ว

    please make a videos on powerbi interview questions

  • @mayankdipesh9705
    @mayankdipesh9705 ปีที่แล้ว +3

    Hi bhaiya
    please try to bring atleast 1 project video every week . The viewers demand :)

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  ปีที่แล้ว +2

      Okayy noted ✅️, even i m thinking something similar to this

  • @surajsinghrajput2168
    @surajsinghrajput2168 4 หลายเดือนก่อน +1

    very very useful

  • @msebntaiyab1414
    @msebntaiyab1414 6 หลายเดือนก่อน +1

    I found the education channel First Aisa Channel to be a good one which gives you the opportunity to learn everything in easy language. I learned a lot from here, that's why I share this channel once every day. Rishabh bhai thank you so much!

  • @anushas1910
    @anushas1910 หลายเดือนก่อน +1

    Please start series in English 😊

  • @mithunpratapsingh1075
    @mithunpratapsingh1075 ปีที่แล้ว +1

    Python with Data Analytics ka full coarse share kro...

  • @vishnuprabhakar7327
    @vishnuprabhakar7327 10 หลายเดือนก่อน +1

    thankyou sir for putting this effort for us

  • @jeetghosh608
    @jeetghosh608 ปีที่แล้ว +1

    Sir, aur question answer video channel mei post karo na.... bohot helpful hoga

  • @bhavaybukkal9696
    @bhavaybukkal9696 3 หลายเดือนก่อน +1

    great video

  • @Anujkumar-rv6wk
    @Anujkumar-rv6wk ปีที่แล้ว

    Graet

  • @niharikamishra9745
    @niharikamishra9745 ปีที่แล้ว +9

    Sir you have set a new milestone to the learners it's a blessing to found your channel and learn from it.
    I have completed your power BI three lectures and literally they are the best ❤❤❤❤❤

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  ปีที่แล้ว +1

      Glad it was helpful ✅️ keep learning n keep growing 🚀

    • @user-rq2bo6hi5g
      @user-rq2bo6hi5g ปีที่แล้ว

      Appka gane ka program kesa chal raha he

  • @dawaiwalabylakshyajainphar3595
    @dawaiwalabylakshyajainphar3595 ปีที่แล้ว +1

    meri galt fehmi the ki jayda subscriber waala
    hi acha sikha hai . Thanks for this type of content.

  • @SnapMathShorts
    @SnapMathShorts 4 หลายเดือนก่อน +1

    SIr , when I divide null with null then it's showing error not null .
    Thanks

  • @playwithvihaan7601
    @playwithvihaan7601 ปีที่แล้ว +1

    Nice content. Please share create and Insert statements in the description box. Thank you.

  • @sachinkale2452
    @sachinkale2452 4 หลายเดือนก่อน +1

    Thank You Rishabh great video 👏

  • @saumyasingh9636
    @saumyasingh9636 ปีที่แล้ว +2

    Very informative video

  • @naveenrawat-yc1op
    @naveenrawat-yc1op ปีที่แล้ว +1

    Thanks bhaiya for making this amazing video.
    Bhaiya when will next video will be uploaded regarding SQL solving questions

  • @adityawasankar7929
    @adityawasankar7929 ปีที่แล้ว +1

    Rishabh please make video on Most common Data Analyst interview questions!

  • @inshortview
    @inshortview ปีที่แล้ว +1

    Reviewing it again before going for an Interview,
    Thankyou Rishabh bhaiya ❤❤

  • @AshishTiwari-ug2lg
    @AshishTiwari-ug2lg 2 หลายเดือนก่อน

    Mishra Ji Rocks 💥💥💥💥💥
    By the way Mishra Ji You are From Where?

  • @tipstricks1142
    @tipstricks1142 7 หลายเดือนก่อน +1

    Useful video sir

  • @balashrim9468
    @balashrim9468 ปีที่แล้ว +1

    very nice vdo and explaining sooo well

  • @PrakharPandey-no9zs
    @PrakharPandey-no9zs ปีที่แล้ว +1

    please keep uploading bhaiya. Nice content

  • @narendrakumarchauhan8928
    @narendrakumarchauhan8928 4 หลายเดือนก่อน

    Q1 ka table provide krne practice ke liye sir ji

  • @harishkumarthakur6600
    @harishkumarthakur6600 11 หลายเดือนก่อน +1

    thankyou bhaiya 😃😃😃

  • @padamthapa1889
    @padamthapa1889 ปีที่แล้ว +1

    Sahab u r king 👑 of SQL plz post many sql video's

  • @ecanalysis7589
    @ecanalysis7589 ปีที่แล้ว +2

    very very helpfull for me sir🙏❤

  • @themag4139
    @themag4139 ปีที่แล้ว +1

    Really HatsOff to your HardWork bro

  • @akankshasoni3479
    @akankshasoni3479 ปีที่แล้ว +1

    Greattttttt!
    Bhaiya please make videos on cte and regex also please

  • @gauravsrivastava17
    @gauravsrivastava17 หลายเดือนก่อน +1

    🔥🔥🔥

  • @arupchandra8602
    @arupchandra8602 ปีที่แล้ว

    Q.14 option A should work...

  • @ShreyasAkode
    @ShreyasAkode 5 หลายเดือนก่อน +1

    thanks sir for making this video

  • @souvikghosh6025
    @souvikghosh6025 ปีที่แล้ว +4

    Sir I'm using Microsoft SQL server. What's the function i use instead of EXTRACT ? Please tell if u feel to answer 🙂

    • @annumaan8435
      @annumaan8435 ปีที่แล้ว

      use year() and month() function to extract year and month from date

  • @manojkule195
    @manojkule195 ปีที่แล้ว +1

    Good information sir

  • @tajinderaulakh8576
    @tajinderaulakh8576 2 หลายเดือนก่อน

    Can you explain qus 10 why maansi is answer bcoz of % sign ???
    And in 14 qus why intiger is in ' ' ?

  • @pritampatil9241
    @pritampatil9241 20 วันที่ผ่านมา

    How to find duplicate rows from employee table in sql server management studio