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

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

[@karishmabhardwaj603]

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

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@akshupatil9604]

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]

Indian paradise Trainer visit this channel

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

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

[@vandanaprajapati2316]

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

[@vinayakdevane9688]

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

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

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

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

[@deveshpadgelwar8895]

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

[@sanketkalevlogs7911]

Please make video on MySQL for data analytics

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

[@unicorn27-01]

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

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

[@sid_analytics]

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

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@jeetghosh608]

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

[@RishabhMishraOfficial]

New video coming tomo!!

[@SnehaSingh-yv1qx]

Ans 1 select from where group by having order by limit

[@roniteraj4201]

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

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@abhayjaiswal4838]

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

[@anshulshukla2595]

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

[@susamay]

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

[@shitalthorat-wm6js]

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

[@RishabhMishraOfficial]

Yess soon video is coming 🙌

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

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

[@dattatrayarathi1014]

Thank you so much sir for a sharing video

[@RishabhMishraOfficial]

Glad you liked ✅️

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

[@aryan043]

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

[@sanmitradas986]

Rishabh, please upload a detailed video on SQL triggers

[@souvikghosh6025]

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

[@annumaan8435]

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

[@jogeshadireddy1065]

DATENAME(month, ‘08/09/024’)

[@jogeshadireddy1065]

DATENAME(month, ‘08/09/024’)

[@ankushthakur6556]

Sir 1st question mei order of execution wale question mei sabse pehle select statement ka use hua hai example mei to fir from kaise?

[@RishabhMishraOfficial]

Likhne mei select pagle aata hai but jab SQL usko samkhjta hai tho vo FROM se shuru karta hai.. jaisa ki iss video mei samjahaya hai

[@ankitgite7141]

Sir plz start python course if possible

[@RishabhMishraOfficial]

Yess soo

[@SalmaNHuNt-i7k]

Bhai Folks na Bolo Viewer hai Aapke 🌴

[@skdonsingh]

😂

[@ja55i51]

Tmkc

[@mayurib5667]

Sir you are explaining very well. Thank you

[@RishabhMishraOfficial]

Glad you liked ✅️

[@playwithvihaan7601]

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

[@RishabhMishraOfficial]

Insert into tablename Values ();

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

[@amanzia2495]

Solution of Question 3 select id,count(skills) as 'coreskills' from [table_name] group by id having count(skills)=3 order by id

[@lifewithdeepika]

Sir please reply me..👏 Maine abhi bca complete ki hai....and mai backend developer mein jana chahti hu...to uske liye interview only SQL/ORACLE kaa hi dena hai ....mtlb sirf yeh do cheeje hi ani chahiye ??? Backend developer ke liye????....

[@RishabhMishraOfficial]

For backend dev i m not sure but yes definitely you should know sql n database management

[@jyotiverma6296]

Sir kya mai data analytics mai apna career bana sakti hu.... right now I am a teacher n i m also 35 yrs old ...am i eligible or not

[@RishabhMishraOfficial]

First thing if you're a teacher then i m your student so pls don't call me sir 😅 Now, yes you're eligible for data analyst job, but for that you need to learn data analytics skills n work on some good industry level projects and finally create your profile/resume n start applying online. Cracking the first job is a little difficult but not impossible. Also, if you want there are wfh jobs available as well

[@jyotiverma6296]

Thankyou so much for your reply.....i watch your videos , learn and practice from it that is enough for data analytics job

[@dawaiwalabylakshyajainphar3595]

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

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@SnapMathShorts]

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

[@tannubajpai4782]

You contain some special talent for explanation

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

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

[@shitalthorat-wm6js]

Thanks a lot sir.... such valuable information

[@padamthapa1889]

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

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@tj.aulakh4]

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

[@mayankgpt50]

What if we have a duplicate in the skill question For example, if we have 101 Python Two times?

[@akankshasoni3479]

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

[@RishabhMishraOfficial]

Glad you liked it ✅️ n noted ✅️

[@sabesanj5509]

solution for question 3: SELECT candidate_id FROM your_table_name WHERE skills IN ('sql', 'python', 'power bi') GROUP BY candidate_id HAVING COUNT(DISTINCT skills) = 3 ORDER BY candidate_id ASC; Is thisone correct solution rishabh bro??

[@AditiSharma-zo5dq]

solution shi h but output table m skill count bhi chahiye to vo bhi select karna hoga

[@sabesanj5509]

@@AditiSharma-zo5dq Please reply in english. I don't understand hindi.

[@AditiSharma-zo5dq]

Your solution is correct but in output table we need skill count too So you have to select it that too

[@anushas1910]

Please start series in English 😊

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

[@roshnisingh1538]

Also please make videos on case study for Data Analyst with more and more questions.

[@RishabhMishraOfficial]

Okayy noted ✅️

[@kingomya45]

Sir best video 📸

[@lakshay16596]

hi Rishabh, just a general question i have certification in Tableau instead of Power BI. do you think its fine or i need to learn Power BI too for my career as a data analyst?

[@mohaiminulislam7111]

you can learn either Tableau or Power BI. no need to learn both.(N.B. power BI is free whereas the Tableau Desktop version is paid)

[@lakshay16596]

@@mohaiminulislam7111 thanks

[@PankajPandey-vc6vc]

The way you explain the things its amazing thanks Rishabh

[@RishabhMishraOfficial]

Glad you liked ✅️

[@MubarakAli-qs9qq]

Best ever tutor

[@ecanalysis7589]

very very helpfull for me sir🙏❤

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@Meta19811]

Bro what level of sql questions they will ask for data analyst interview???? Please reply

[@RishabhMishraOfficial]

That depends on role n orher factors but mostly For freshers it can be between easy to intermediate level.

[@rushikeshkharat4022]

python k liye bhi koi series hai kya bhaiyya?

[@RishabhMishraOfficial]

Coming soon on this channel

[@Khansarah]

Very informative video in simple way … 👍

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@muhammadmazhar8596]

Execellent presentation Respected Sir

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@saumyasingh9636]

Very informative video

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@shamanthrao528]

thank you so much

[@RishabhMishraOfficial]

Glad you liked ✅️

[@mohammedshabaaz9625]

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

[@RishabhMishraOfficial]

Okayy noted ✅️

[@HemaSahoo]

Very well explained. Thanks a ton!!!!

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@mithunpratapsingh1075]

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

[@hitensawant5505]

SIR MAKE A VIDEO ON ONE END TO END PROJECT USING EXCEL, SQL, AND POWER BI !

[@RishabhMishraOfficial]

Noted ✅️

[@avinasht687]

Power Bi or tablue which is better Sir

[@RishabhMishraOfficial]

For mr Power bi is more user friendly n easy to use

[@YourYTHUB]

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

[@RishabhMishraOfficial]

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

[@qaviahmed4791]

Bro plz do a project as a data analyst which includes exel, sql,py,power bi so that we have a clear view of what data analyst does..plzzzz

[@RishabhMishraOfficial]

okayy noted !

[@qaviahmed4791]

@@RishabhMishraOfficial thanks bro

[@Hellyeah22916]

Qaviahmed bhi Py is python?

[@qaviahmed4791]

@@Hellyeah22916 yes

[@Hellyeah22916]

@@qaviahmed4791 upka linkdin share kijiye i will connect u for talking

[@manishachauhan-xl9lx]

Sir it is enough to learn SQL

[@RishabhMishraOfficial]

Practice more

[@manishachauhan-xl9lx]

Thanks sir

[@ShivamTiwari-pw2qx]

Can we use the given set of codes in workbench also?

[@RishabhMishraOfficial]

Yess absolutely

[@dipeshpatel8625]

Hey sir; can you tell us one video how to solve hacker rank and leetcode questions

[@RishabhMishraOfficial]

Noted ✅️

[@ayushiagarwal7370]

which is the most used sql by companies and what is the difference between mysql & postgre sql

[@RishabhMishraOfficial]

That depends on company it could be google big query, snowflake, aws athena etc

[@MahammedKareemulla]

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

[@vishnuprabhakar7327]

thankyou sir for putting this effort for us

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@themag4139]

Really HatsOff to your HardWork bro

[@RishabhMishraOfficial]

Glad you liked ✅️

[@mdaqueel3019]

Can I get the job of Data Analyst on the base of Power Bi and Microsoft Excel, please tell me sir

[@RishabhMishraOfficial]

Yes

[@akhileshsharma9040]

Aap thodaa sql se related job ke baare mebhi bataa diyaa karen

[@RishabhMishraOfficial]

Okay noted ✅️

[@akhileshsharma9040]

@@RishabhMishraOfficial Dhanyavaad but Asa a fresher dhundnaa kyuki koi experience nahi hai hame aur companies vaise bhi experience vaalo ko hi lenaa canteen hai badi deekkat hoti hai kaam koi detaa nahi aur sabko experience vaale log lene toh dhayan denaa bhaiyaa.

[@eshanksharma7616]

Good content

[@irfanha8245]

Data analyst job interview questions please

[@NidhiKUMARI-zg1sx]

sir, we cant use operation like "=" with null , right? here in question it was used.

[@RishabhMishraOfficial]

Use IS operators

[@harshitdubey3768]

Great

[@RishabhMishraOfficial]

Glad you liked ✅️

[@zahidalam7831]

You explained very well sir I m waiting for another video

[@pawankumarnalla1535]

Sir main non code background Tyba i passionate for data analysis i learn your channel your are teaching so good can I get me

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@ruchimaurya1102]

Rishabh can you please make videos on R programming?

[@RishabhMishraOfficial]

Okayy noted ✅️

[@ShreyasAkode]

thanks sir for making this video

[@RishabhMishraOfficial]

Glad you liked ✅️

[@AshishTiwari-ug2lg]

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

[@Arshadpathan-f7d]

Thanks for PDF ❤

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@nbadya2674]

thank you

[@technicalknowledge9128]

SIR YE BATAYE SQL KON SA SIKHE OR YE KITNE TYPE KE HOTE HE OR KON SE SQL JAYDA USE HOTE HE QUNFUSION HE THODI SI CLEAR KRE SIR

[@RishabhMishraOfficial]

Covered these points in SQL Tutorial Playlist, watch first video what is sql introduction

[@Thesimpleworld99]

Bhiya course ka link share krdo please mujhe basics clear krna hai

[@SandipanSarkar-c8v]

Finished watching

[@RishabhMishraOfficial]

Awesome, glad you liked ✅️

[@surajsinghrajput2168]

very very useful

[@RishabhMishraOfficial]

Glad you liked ✅️

[@harishkumarthakur6600]

thankyou bhaiya 😃😃😃

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Meditarya]

having executes after select

[@priyankapujari6154]

Please bro use English language to teaching 🙏🙏🙏ur video's so much useful for every one

[@RishabhMishraOfficial]

Noted ✅️

[@sameer2532]

Sir please make more interview question videos

[@RishabhMishraOfficial]

Noted ✅️

[@arupchandra8602]

Q.14 option A should work...