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

[@sahil-dogra]

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]

Excellent! Keep learning n keep growing 🚀

[@NIDHIMAHESHWARI-x8u]

in which company ? which types question will asked you?

[@Harshal__Patil]

Which other questions they asked

[@g.v.snitin8825]

Idiot say which question and which company name what will be useful for us for sharing this without the actual questions rip society

[@vinayakdevane9688]

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

[@karishmabhardwaj603]

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

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@akshupatil9604]

Hiiiii

[@vandanaprajapati2316]

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

[@harshitverma1263]

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

[@RishabhMishraOfficial]

More to come!

[@rishav144]

best channel for Data Science

[@RishabhMishraOfficial]

Glad you think so ✨️

[@satyastocks3773]

One of the best learning channel thank you very much sir

[@RishabhMishraOfficial]

Glad you liked ✅️

[@susamay]

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

[@shakuntalakumari8460]

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

[@Aditya61515]

Indian paradise Trainer visit this channel

[@TataNaresh]

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

[@aryan043]

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

[@mantoshroy4076]

Keep continue sir 😊🙏 Great content ❤️😍👌

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@MdRizwan-uu9dv]

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]

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]

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

[@shreyadas4699]

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

[@MoNiKa-29-RN]

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

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@shitalthorat-wm6js]

Thanks a lot sir.... such valuable information

[@abhayjaiswal4838]

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

[@VIKASHSINGH-zg1lx]

Well explained 🥳

[@RishabhMishraOfficial]

👍

[@ManKR]

Your Content is always nextLevel Thankyou sir.

[@kingomya45]

Sir best video 📸

[@HemaSahoo]

Very well explained. Thanks a ton!!!!

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@roniteraj4201]

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

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@sachinkale2452]

Thank You Rishabh great video 👏

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@msebntaiyab1414]

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!

[@RishabhMishraOfficial]

Glad you liked ✅️

[@niharikamishra9745]

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]

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

[@ganeshauti-f1s]

Appka gane ka program kesa chal raha he

[@harishkumarthakur6600]

thankyou bhaiya 😃😃😃

[@RishabhMishraOfficial]

Glad you liked ✅️

[@mohinikunwar1621]

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😍🧿

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@muhammadmazhar8596]

Execellent presentation Respected Sir

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@pratoshkumarjha89]

Kindly continue this series on Important Questions on SQL

[@RishabhMishraOfficial]

Coming soon ✅️

[@ujjwalkhandelwal5132]

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👍

[@RishabhMishraOfficial]

Ok. Thanks 👍

[@PankajPandey-vc6vc]

The way you explain the things its amazing thanks Rishabh

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Arshadpathan-f7d]

Thanks for PDF ❤

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@sid_analytics]

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

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@inshortview]

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

[@RishabhMishraOfficial]

All the very best brother 👍

[@ashishkaushik5753]

How was your Interview gone, bro? 🙄

[@ecanalysis7589]

very very helpfull for me sir🙏❤

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@hims5205]

I was asked in recent interview for QA manual 1. Find the list of employees in which 2nd letter is 'A'. 2 Find the 2nd highest salary 3. Aggregate functions 4.Constraints in SQl

[@Yourhotshorts]

Bhai boht easy hai 4wo questions

[@bindusharma8625]

for which company, deloitte?

[@hims5205]

@@bindusharma8625 Pinelabs

[@mayurib5667]

Sir you are explaining very well. Thank you

[@RishabhMishraOfficial]

Glad you liked ✅️

[@g.v.snitin8825]

The way you provided code even for creating the input table,hats off sir

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@Adesh_009]

Thank you soo much 🎉

[@mayankchauhan5386]

Thanks for this Content ❤.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@balashrim9468]

very nice vdo and explaining sooo well

[@RishabhMishraOfficial]

Glad you liked ✅️

[@dattatrayarathi1014]

Thank you so much sir for a sharing video

[@RishabhMishraOfficial]

Glad you liked ✅️

[@sushantmeshram5172]

thank you so much Rishab

[@sudhansubhol6052]

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

[@gauravbatra982]

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

[@saumyasingh9636]

Very informative video

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@Khansarah]

Very informative video in simple way … 👍

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@Ramesh00300]

@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]

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 ✅️

[@tannubajpai4782]

You contain some special talent for explanation

[@roshnisingh1538]

Hi sir, Please make more videos on scenario based questions. Your explaination to queries are great. Please make more such content in postgresql.

[@unicorn27-01]

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

[@vishnuprabhakar7327]

thankyou sir for putting this effort for us

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@PatialaKing-up2te]

Thank you sir ❤❤

[@anshumankumar9342]

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

[@RishabhMishraOfficial]

Noted.. will do ✅️

[@taqdeeszahra1139]

Sir msc mathematics can become python data analyst

[@sanketkalevlogs7911]

Please make video on MySQL for data analytics

[@tusharchaudhary7937]

Keep it up sir 👍 very helpful content 😊

[@MohammedShoaib-i9l]

Keep up the good work I find your videos really helpful.

[@YourYTHUB]

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

[@RishabhMishraOfficial]

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

[@themag4139]

Really HatsOff to your HardWork bro

[@RishabhMishraOfficial]

Glad you liked ✅️

[@MubarakAli-qs9qq]

Best ever tutor

[@tipstricks1142]

Useful video sir

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@eshanksharma7616]

Good content

[@akankshasoni3479]

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

[@RishabhMishraOfficial]

Glad you liked it ✅️ n noted ✅️

[@AshishTiwari-ug2lg]

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

[@manishachauhan-xl9lx]

Sir it is enough to learn SQL

[@RishabhMishraOfficial]

Practice more

[@manishachauhan-xl9lx]

Thanks sir

[@Archtech-on1qq]

Helpfull...👍

[@RishabhMishraOfficial]

Glad it helped ✅️

[@AzharEdTech]

you are the best

[@mohammedshabaaz9625]

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

[@RishabhMishraOfficial]

Okayy noted ✅️

[@PrakharPandey-no9zs]

please keep uploading bhaiya. Nice content

[@RishabhMishraOfficial]

More videos coming soon

[@anushas1910]

Please start series in English 😊

[@memories_1008]

Best course✨🙌🏻

[@RishabhMishraOfficial]

Glad you liked ✅️

[@sagar857]

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

[@RishabhMishraOfficial]

Glad you liked ✅️ n noted ✅️

[@sanmitradas986]

Rishabh, please upload a detailed video on SQL triggers

[@nbadya2674]

thank you

[@Crazy_Clips_R]

from-> join-> on-> where-> group by-> having-> select-> order by -> limit

[@dawaiwalabylakshyajainphar3595]

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

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@ShreyasAkode]

thanks sir for making this video

[@RishabhMishraOfficial]

Glad you liked ✅️

[@SAW8149]

Great

[@jeetghosh608]

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

[@RishabhMishraOfficial]

New video coming tomo!!

[@playwithvihaan7601]

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

[@RishabhMishraOfficial]

Insert into tablename Values ();

[@riteshgaihre6277]

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

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

[@surajsinghrajput2168]

very very useful

[@RishabhMishraOfficial]

Glad you liked ✅️

[@padamthapa1889]

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

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@sushantprabhu007]

Excellent videos Mishra ji. Aise video dekhe nahi kabhi

[@RishabhMishraOfficial]

Glad you liked ✅️

[@santoshlohar1103]

40k congratulations ❤

[@RishabhMishraOfficial]

Thanks Santosh ✅️

[@zahidalam7831]

You explained very well sir I m waiting for another video

[@mayankdipesh9705]

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

[@RishabhMishraOfficial]

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

[@shitalthorat-wm6js]

Sir ek request thi... please paython me bhi videos and project mil skte he kya

[@RishabhMishraOfficial]

Yess soon video is coming 🙌

[@beingrishi6450]

Awesome

[@bhavinpadhiyar9829]

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

[@gauravsrivastava17]

🔥🔥🔥

[@ajent7]

thanks bro

[@RishabhMishraOfficial]

Glad you liked ✅️

[@deveshpadgelwar8895]

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

[@ankitgite7141]

Sir plz start python course if possible

[@RishabhMishraOfficial]

Yess soo

[@RK-wf7re]

Hi, excellent content. Can't we write extract (month from order date) to retrieve month?

[@RishabhMishraOfficial]

Glad you liked it ✅️ Yes you can but all of this depends on which database u are working on.

[@RK-wf7re]

@@RishabhMishraOfficial Thank you so much for your prompt response.

[@aasmohammad6332]

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

[@RishabhMishraOfficial]

Noted ✅️

[@anshulshukla2595]

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

[@adityawasankar7929]

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

[@RishabhMishraOfficial]

Noted ✅️

[@naveenrawat-yc1op]

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

[@RishabhMishraOfficial]

Mostly This Saturday

[@souvikdas9110]

Could you please share the database for practice plss 👍👍👍

[@RishabhMishraOfficial]

Alresdy shared, link in video description