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

Рет қаралды 329,539

Күн бұрын

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

@vandanaprajapati2316 Жыл бұрын

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

@TataNaresh Жыл бұрын

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

@vinayakdevane9688 Жыл бұрын

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

@susamay Жыл бұрын

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

@aryan043 Жыл бұрын

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

@shitalthorat-wm6js Жыл бұрын

Thanks a lot sir.... such valuable information

@sudhansubhol6052 Жыл бұрын

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

@ManKR Жыл бұрын

Your Content is always nextLevel Thankyou sir.

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

@riteshgaihre6277 6 ай бұрын

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

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

@abhayjaiswal4838 16 күн бұрын

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

@tannubajpai4782 Жыл бұрын

You contain some special talent for explanation

@karishmabhardwaj603 Жыл бұрын

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

@RishabhMishraOfficial Жыл бұрын

Glad you liked the content ✅️

@akshaylonari2537 Жыл бұрын

Hiiiii

@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 5 ай бұрын

Indian paradise Trainer visit this channel

@zahidalam7831 4 ай бұрын

You explained very well sir I m waiting for another video

@tusharchaudhary7937 Жыл бұрын

Keep it up sir 👍 very helpful content 😊

@RahulMishra-oc7dv Жыл бұрын

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

@sushantmeshram5172 Ай бұрын

thank you so much Rishab

@PatialaKing-up2te Ай бұрын

Thank you sir ❤❤

@sanmitradas986 6 ай бұрын

Rishabh, please upload a detailed video on SQL triggers

@AzharWahajIjtaba 9 ай бұрын

you are the best

@eshanksharma7616 Жыл бұрын

Good content

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

@nbadya2674 Жыл бұрын

thank you

@bhavinpadhiyar9829 4 ай бұрын

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

@kingomya45 7 ай бұрын

Sir best video 📸

@SAW8149 Жыл бұрын

Great

@beingrishi6450 Жыл бұрын

Awesome

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

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

@roniteraj4201 Жыл бұрын

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

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✨️

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

@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

@sahil-dogra 10 ай бұрын

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 10 ай бұрын

Excellent! Keep learning n keep growing 🚀

@user-wt5rs6jr7u 10 ай бұрын

in which company ? which types question will asked you?

@Harshal__Patil 10 ай бұрын

Which other questions they asked

@sanketkalevlogs7911 Жыл бұрын

Please make video on MySQL for data analytics

@HemaSahoo Жыл бұрын

Very well explained. Thanks a ton!!!!

@RishabhMishraOfficial Жыл бұрын

Glad it was helpful ✅️

@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 10 ай бұрын

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

@iloveyourstatus3929 Жыл бұрын

Nice

@sagar857 9 ай бұрын

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 9 ай бұрын

Glad you liked ✅️ n noted ✅️

@lifeisbeautiful1111 10 ай бұрын

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

@mantoshroy4076 Жыл бұрын

Keep continue sir 😊🙏 Great content ❤️😍👌

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✨️

@shubhangidhakane6922 Жыл бұрын

good

@Khansarah Жыл бұрын

Very informative video in simple way … 👍

@RishabhMishraOfficial Жыл бұрын

Glad it was helpful! ✅️

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

@user-rq2bo6hi5g Жыл бұрын

Appka gane ka program kesa chal raha he

@rishav144 Жыл бұрын

best channel for Data Science

@RishabhMishraOfficial Жыл бұрын

Glad you think so ✨️

@sid_analytics 3 ай бұрын

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

@RishabhMishraOfficial 3 ай бұрын

Glad it was helpful! ✅️

@deveshpadgelwar8895 Жыл бұрын

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

@PankajPandey-vc6vc 11 ай бұрын

The way you explain the things its amazing thanks Rishabh

@RishabhMishraOfficial 11 ай бұрын

Glad you liked ✅️

@shubham_vishwakarma97 11 ай бұрын

For MySQL you can also use below query it will show month name also :-- SELECT YEAR (order_date) AS Years, MONTHNAME(order_date) AS Months, SUM(sales) AS TotalSales FROM Products GROUP BY YEAR(order_date), MONTHNAME(order_date) ORDER BY TotalSales;

@Demoautomation 11 ай бұрын

Error-----'MONTHNAME' is not a recognized built-in function name.

@Demoautomation 11 ай бұрын

If you are getting the same Error in Q2 you can also use For MySQL :-- SELECT YEAR(order_date) AS Years, MONTH(order_date) AS Months, SUM(sales) AS TotalSales FROM Products GROUP BY YEAR(order_date), MONTH(order_date) ORDER BY TotalSales;

@pratoshkumarjha89 Жыл бұрын

Kindly continue this series on Important Questions on SQL

@RishabhMishraOfficial Жыл бұрын

Coming soon ✅️

@unicorn27-01 3 күн бұрын

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

@satyastocks3773 Жыл бұрын

One of the best learning channel thank you very much sir

@RishabhMishraOfficial Жыл бұрын

Glad you liked ✅️

@mohammedshabaaz9625 Жыл бұрын

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

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@muhammadmazhar8596 Жыл бұрын

Execellent presentation Respected Sir

@RishabhMishraOfficial Жыл бұрын

Glad it was helpful ✅️

@Anujkumar-rv6wk Жыл бұрын

Graet

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

@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

@mayurib5667 3 ай бұрын

Sir you are explaining very well. Thank you

@RishabhMishraOfficial 3 ай бұрын

Glad you liked ✅️

@vishnuprabhakar7327 10 ай бұрын

thankyou sir for putting this effort for us

@RishabhMishraOfficial 10 ай бұрын

Glad you liked it ✅️

@user-wu5zo1th5o 6 ай бұрын

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

@surajsinghrajput2168 4 ай бұрын

very very useful

@RishabhMishraOfficial 4 ай бұрын

Glad you liked ✅️

@YourYTHUB 11 ай бұрын

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

@RishabhMishraOfficial 11 ай бұрын

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

@Archtech-on1qq 11 ай бұрын

Helpfull...👍

@RishabhMishraOfficial 11 ай бұрын

Glad it helped ✅️

@bhavaybukkal9696 3 ай бұрын

great video

@RishabhMishraOfficial 3 ай бұрын

Glad you liked it ✅️

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

@dattatrayarathi1014 9 ай бұрын

Thank you so much sir for a sharing video

@RishabhMishraOfficial 9 ай бұрын

Glad you liked ✅️

@tipstricks1142 6 ай бұрын

Useful video sir

@RishabhMishraOfficial 6 ай бұрын

Glad you liked it ✅️

@sachinkale2452 4 ай бұрын

Thank You Rishabh great video 👏

@RishabhMishraOfficial 4 ай бұрын

Glad you liked it ✅️

@saumyasingh9636 Жыл бұрын

Very informative video

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✨️

@msebntaiyab1414 6 ай бұрын

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 6 ай бұрын

Glad you liked ✅️