Top SQL interview Questions and Answers | Most Asked SQL Questions for Job interview
Vložit
- čas přidán 11. 09. 2024
- 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
One of My best learning Channel..... Thanks for this video Sir... :)
Glad you liked the content ✅️
Hiiiii
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
More to come!
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.
Excellent! Keep learning n keep growing 🚀
in which company ? which types question will asked you?
Which other questions they asked
Very Useful and explained very easily ....Waiting for Part 2 Interview Questions
Hi Rishabh, please suggest some most asked questions in Power Bi & Dax at the intermediate level. U can also share the questions only.
Indian paradise Trainer visit this channel
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
Bhai boht easy hai 4wo questions
for which company, deloitte?
@@bindusharma8625 Pinelabs
best channel for Data Science
Glad you think so ✨️
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.
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!
Yes, for comparing Null values we don't use equal operators in sql.
We always use 'Col_name is Null'
true...we can't use equals to operator for comparing nulls...I got stuck at the same thing watching the video
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!
Glad you liked ✅️
@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 ?
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 ✅️
Sir tumhi khup changl shikvta youtube vr best samjel as shikvnare tumhich ahat ❤
One of the best learning channel thank you very much sir
Glad you liked ✅️
all videos are amazing... also u provide a pdf that is very useful.. Thank you so much, sir.
Glad it was helpful ✅️
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 ❤❤❤❤❤
Glad it was helpful ✅️ keep learning n keep growing 🚀
Appka gane ka program kesa chal raha he
Kindly continue this series on Important Questions on SQL
Coming soon ✅️
I think this is easy compare to you for skills>3
Select candidate_id,count(*) from tablename group by candidate_id having count(*)>2;
Very helpful! Thank you very much. Am literally watching this video one day before my interview
Glad it was helpful! ✅️
Nicely explained today learnt something new. Thank you Rishabh bhai🙌
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
Noted.. will do ✅️
Sir msc mathematics can become python data analyst
please make more videos like this also please make a oneshot video on mysql
Sir, thanks for such videos which are very helpful for data aspirants
Glad you liked it ✨️
Ans 1 select from where group by having order by limit
Please make video on MySQL for data analytics
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👍
Ok. Thanks 👍
Really great channel. Your quality is at it's peak.
Keep continue sir 😊🙏
Great content ❤️😍👌
Glad you liked it ✨️
How to find duplicate data without using group by clause and distinct ? Using CTE
Wow loved the way Rishab teaching SQL concepts enjoyed video.🤩
Hi bhaiya
please try to bring atleast 1 project video every week . The viewers demand :)
Okayy noted ✅️, even i m thinking something similar to this
Thank you so much sir for a sharing video
Glad you liked ✅️
Your Content is always nextLevel
Thankyou sir.
Sir, aur question answer video channel mei post karo na.... bohot helpful hoga
New video coming tomo!!
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😍🧿
Glad it was helpful! ✅️
Sir thank uh so much for providing such a usefull and effective content!! So can uh pls make video on full fledge SQL project!?
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??
Glad you liked ✅️ n noted ✅️
Thanks bro..very helpful.. best of luck for channel.. learning more from you..
Please create a video for Python and Tableau and Power BI interview question-answer
Sir ek request thi... please paython me bhi videos and project mil skte he kya
Yess soon video is coming 🙌
Best ever tutor
Thank you sir , really valuable questions for us.
Please upload a video on Tableau project.
from-> join-> on-> where-> group by-> having-> select-> order by -> limit
Reviewing it again before going for an Interview,
Thankyou Rishabh bhaiya ❤❤
All the very best brother 👍
How was your Interview gone, bro? 🙄
Sir you are explaining very well. Thank you
Glad you liked ✅️
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;
Error-----'MONTHNAME' is not a recognized built-in function name.
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;
Nice content. Please share create and Insert statements in the description box. Thank you.
Insert into tablename
Values ();
Hi Rishabh, PDF me ek jagah typo error h.
Question No 3 me.
Sir I'm using Microsoft SQL server. What's the function i use instead of EXTRACT ? Please tell if u feel to answer 🙂
use year() and month() function to extract year and month from date
DATENAME(month, ‘08/09/024’)
DATENAME(month, ‘08/09/024’)
Sir 1st question mei order of execution wale question mei sabse pehle select statement ka use hua hai example mei to fir from kaise?
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
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
Noted ✅️
The way you explain the things its amazing thanks Rishabh
Glad you liked ✅️
Rishabh, please upload a detailed video on SQL triggers
meri galt fehmi the ki jayda subscriber waala
hi acha sikha hai . Thanks for this type of content.
Glad you liked it ✨️
valuable content brother ...and congratulations brother u marked 120k subs. keep growing
Glad you liked it ✅️ n thank you so much brother 🙌
Very informative video in simple way … 👍
Glad it was helpful! ✅️
Sir plz start python course if possible
Yess soo
You contain some special talent for explanation
Greattttttt!
Bhaiya please make videos on cte and regex also please
Glad you liked it ✅️ n noted ✅️
Please start series in English 😊
Rishabh please make video on Most common Data Analyst interview questions!
Noted ✅️
Keep up the good work
I find your videos really helpful.
Hi, excellent content. Can't we write extract (month from order date) to retrieve month?
Glad you liked it ✅️
Yes you can but all of this depends on which database u are working on.
@@RishabhMishraOfficial Thank you so much for your prompt response.
Sir best video 📸
very very helpfull for me sir🙏❤
Glad you liked it ✨️
Execellent presentation Respected Sir
Glad it was helpful ✅️
Thanks a lot sir.... such valuable information
Sahab u r king 👑 of SQL plz post many sql video's
Glad you liked it ✅️
Solution of Question 3
select id,count(skills) as 'coreskills'
from [table_name]
group by id
having count(skills)=3
order by id
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????....
For backend dev i m not sure but yes definitely you should know sql n database management
you are very hardworking, genius. you have put lots of efforts to make this videos. I CAN understand. thank you so much
Very informative video
Glad you liked it ✨️
Mishra Ji Rocks 💥💥💥💥💥
By the way Mishra Ji You are From Where?
Thanks bhaiya for making this amazing video.
Bhaiya when will next video will be uploaded regarding SQL solving questions
Mostly This Saturday
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 .
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
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
Thankyou so much for your reply.....i watch your videos , learn and practice from it that is enough for data analytics job
Thank you for this video, Rishabh!! Congratulations for completing 202K subscribers on this channel...
Very well explained. Thanks a ton!!!!
Glad it was helpful ✅️
Sir we want powerbi,tableau, excel questions also. so please make video for this . Thankyou
Okayy noted ✅️
Thank You Rishabh great video 👏
Glad you liked it ✅️
Broo upload more questions videos till now you have just uploaded 4 videos we need more videos
Okayy noted ✅️
please more more parts of such amazing videos.
will be helpful
Okayy noted ✅️
Rishab bhai aap bohot badhiya kaam kar rhe ho bhagwan aapka bhala kare
Jai shri Ram🚩🔥
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?
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)
@@mohaiminulislam7111 thanks
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??
solution shi h but output table m skill count bhi chahiye to vo bhi select karna hoga
@@AditiSharma-zo5dq Please reply in english. I don't understand hindi.
Your solution is correct but in output table we need skill count too
So you have to select it that too
Really HatsOff to your HardWork bro
Glad you liked ✅️
thank you so much Rishab
thank you so much
Glad you liked ✅️
Thank you soo much 🎉
very nice vdo and explaining sooo well
Glad you liked ✅️
thankyou sir for putting this effort for us
Glad you liked it ✅️
What if we have a duplicate in the skill question
For example, if we have 101 Python Two times?
in mysql the monthname function will be used to get month name not just month.
awaited for......complete data science project where excel ,sql,python & tableu used. @Rishabh Mishra
Okayy noted ✅️
Good content
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
please keep uploading bhaiya. Nice content
More videos coming soon
Aur videos Q/A pe post kariye , it's really helpful
Already uploaded one more video watch that it had advance questions as well
Can you explain qus 10 why maansi is answer bcoz of % sign ???
And in 14 qus why intiger is in ' ' ?
Thanks for PDF ❤
Glad you liked it ✅️
Rishabh bhai, plz create a video on Python what is use of python in project by practically
Okayy noted ✅️
SIr , when I divide null with null then it's showing error not null .
Thanks