@@RishabhMishraOfficial one request Bhaiya if you have more questions on SQL related to interview please share with us as soon as possible. I almost done with SQL for data analyst interview. Right now I am practicing. I loved your content 🔥🔥🔥
Your teaching is truly exceptional. Your SQL tutorials have been an immense help to me. I was wondering if you might consider creating a comprehensive video series that covers Power BI, starting from the basics and progressing to advanced topics. Your teaching style is fantastic, and I believe many learners, including myself, would greatly benefit from such a series.
Hi Rishabh..I am in USA and have passion to be a Data Analyst..I have started my journey by watching your videos..your knowledge is wonderful and u explain super simply..am excited to move on and complete this journey with your help.. Thanks 🙏
for 6th question we can also use simple window function to solve it: with cte as( select *,dense_rank() over(order by salary desc) as rnk from Employee ) select distinct cte.salary from cte where cte.rnk = 2 # 2nd highest salary
Hey brother !! SQL Server: Since you mentioned SQL Server, focus on learning the specific features and tools provided by SQL Server, such as SQL Server Management Studio (SSMS) for administration, SQL Server Integration Services (SSIS) for data integration, and SQL Server Reporting Services (SSRS) for reporting. Please make video on this
Thank you so much Rishabh sir for this sql question and answers series....You are great❤❤❤You are the best teacher in the whole world.... Because of you i learnt sql from scratch....Keep posting more videos on these topics...we all love you ❤❤❤❤ lots of love❤More power to you....
Brother, we have one query, that is, which type of data are used to analyse in mnc firms where we are supposed to work. Please make one project on power BI related to that problem. For example any of the queries related to your job profile, will give us more confidence 🙏
Hlw, Sir, I am from Bangladesh, but i can understand hindi very fluently . Your teaching method is awsome . I have started your Data analysis road map.
You are great and no 1 who made excellent projects . I learnt how to make dashboards on excel from u only and also sql from u and power bi ❤❤❤❤❤. Thanks for everything bhaiya . We are expecting lot from you . Please make combined projects like sql+ tabluea or sql + excel bhaiya
another way:- SELECT COUNT(CASE WHEN Gender = 'M' THEN 1 ELSE null END) * 100.0 / COUNT(*) AS MalePercentage , COUNT(CASE WHEN Gender = 'F' THEN 1 ELSE null END) * 100.0 / COUNT(*) AS FemalePercentage FROM Employee;
Thank you Rishabh , I started my Data Analyst journey 4 months back from your videos and its been monumental for me. I have a request to please make a demo video on " updating resume as per the job requirement" . I have been applying for DA job but getting rejections from everywhere. I think there's need of a change in the way I apply. Also, I got really happy to know that You are also an APS alumni.
Om Shanti Your teaching practice is good. But you explain with accounting situation just like receipt, payment, invoice, customer master, item master, employee master, account group master, in this validation, min. Max. Reorder level & save with text box feed.
Hi Rishabh, Thanks a lot for this awesome video. Will you please reply this-: Alias doesn’t work with where clause ( I understand this reason ) then Why Alias works with “Having Clause “ . Don’t understand clear reason behind this. Thanks
Q7(b) select empname,project from employee as co inner join employedetail as ed on co.empid=ed.empid Group By empname,project it can be done by this method also
delete from employee where empid in (select empid from employee group by empid having (count (*))>1); this query deletes all the records we should implement the query to delete duplicates and it should keep 1 record out of duplicates records.
Sir, Good Morning...Thank you for all sql videos, im ur obedient student from odisha...Sir, question no 2(b) "filter" query is not working in mysql ..so, i have written like these lengthy process but it works... "select ((select count(empid) from employee where gender='M')*100)/(select count(empid) from employee) as male_ratio, ((select count(empid) from employee where gender='F')*100)/(select count(empid) from employee) as female_ratio;"
Hello Sir, @ 7:23 are you using joins in the Table? If Yes, then why u r not using Join word. is it bcoz of self join,we can go without mentioning Joins. >>select E1.employeename, E2.city From Employee E1,Employee E2 where E1.City=E2.city
Bhaeya apke videos dekh kar sql and excel Sikh liya and 2 projects bhi bana diye, first of all thanks for that providing such valuable knowledge, but mujhe portfolio banana nahi aa raha, kya aap ekbar apne music sql project ka portfolio bana k dengey jab bhi aap k pass time ho.
Hello sir apke guide se bht kch clear hua hai sir mai mba in business analytics kr rhi hubut mera background psychology graduate h but mai basic power bi, sql basic , basic paython or Excel janti hu mujhe Carrer kaise start krna chahiye data analytics me job mil payega yah fir business analytics se start krna shi hoga as a fresher
Best teacher, i would understand your teachings easily Alhamdulillah. I have watched and taken notes of your excel, sql and power bi videos. Waiting for python videos. You keep teaching and keep growing.
One more solution for finding Nth Salary Using Rank Method : WITH cte AS( SELECT *, RANK() OVER(ORDER BY salary DESC) FROM employee ORDER BY salary DESC ) SELECT * FROM cte WHERE rank = N
Q. 7 b the easiest approach is Select empname, project from employee inner join employeedetail on employee.empid = employeedetail.empid group by project having count (*) >1
hi rishabh i have a doubt in hackerrank top eaner problem the solution with worked is select months * salary , count(employee_id) from employee group by months * salary order by months * salary desc limit 1 ; but i thought abt an alternate solution but it didnot worked select months * salary , count(employee_id) from employee where months * salary = (select max(months * salary) from employee); in chatgpt they both are giving same result with multiple examples can you tell me how these two are diffrent ?
Rishabh bhaiya .. can you please provide other way for male: female ratio Because sir Filter function only work with postgre SQL and SQL lite ... It will not work with SQL server and oracle
Dear sir your question 7(b) if only two people in same project then it is ok but when 3 or more people in same project then it is not good approach to search people in same Project. Well, I am your Student and I really respect you and your Way of Teaching.
First of all Thank you Mr. Rishabh to make this awesome & helpful video, please help me to resolve one doubt of question 4, where you used Emp.Rownumber % 2 = 0, my doubt is why did you use operater '%' instead of operator '/ ' thanks in advance , will wait for your reply
ANSWER 1(b)................ (another approach) Select empid, empname, gender, salary, city from ( select *, rank() over(partition by city ), count(*) over(partition by city) from employee) y where y.count>1;
Q1(b): Write a query to retrieve the list of employees from the same city. SELECT city, GROUP_CONCAT(empname) as 'employees list' FROM employee GROUP BY city HAVING COUNT(1) > 1;
Hey Rishabh , really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .
Awesome Bhaiya 🔥🔥🔥
I learned whole SQL from your videos. Your explanation is another level🔥🔥.
Glad it was helpful ✅️
Keep learning n keep growing 🚀
Mere job interview mei bhi same questions aye the 👍👍
This is best 👍
@@RishabhMishraOfficial one request Bhaiya if you have more questions on SQL related to interview please share with us as soon as possible. I almost done with SQL for data analyst interview. Right now I am practicing.
I loved your content 🔥🔥🔥
@@sanchitkanojia5460 gud luck 🤞
Your teaching is truly exceptional. Your SQL tutorials have been an immense help to me. I was wondering if you might consider creating a comprehensive video series that covers Power BI, starting from the basics and progressing to advanced topics. Your teaching style is fantastic, and I believe many learners, including myself, would greatly benefit from such a series.
Hi Rishabh..I am in USA and have passion to be a Data Analyst..I have started my journey by watching your videos..your knowledge is wonderful and u explain super simply..am excited to move on and complete this journey with your help.. Thanks 🙏
for 6th question we can also use simple window function to solve it:
with cte as(
select *,dense_rank() over(order by salary desc) as rnk
from Employee
)
select distinct cte.salary from cte
where cte.rnk = 2 # 2nd highest salary
yes and that is simple too ,i did that way
As a general thumb rule we shouldn’t write co related sub queries in practice because of poor performance so better to use window functions
How to get employee name with nth highest salary
Hello rishabh sir questions and answers of SQL interview questions please make video on python practical interview questions
Great work Rishabh. You're the best. 100% trust in your work and efforts.
Hey brother !!
SQL Server: Since you mentioned SQL Server, focus on learning the specific features and tools provided by SQL Server, such as SQL Server Management Studio (SSMS) for administration, SQL Server Integration Services (SSIS) for data integration, and SQL Server Reporting Services (SSRS) for reporting.
Please make video on this
Best sql qna video, was waiting for this video ❤❤🙏🙏
Glad you liked it ✅️
This is best SQL questions video 👍
Thank you so much Rishabh sir for this sql question and answers series....You are great❤❤❤You are the best teacher in the whole world.... Because of you i learnt sql from scratch....Keep posting more videos on these topics...we all love you ❤❤❤❤ lots of love❤More power to you....
Brother, we have one query, that is, which type of data are used to analyse in mnc firms where we are supposed to work. Please make one project on power BI related to that problem. For example any of the queries related to your job profile, will give us more confidence 🙏
Hlw, Sir, I am from Bangladesh, but i can understand hindi very fluently . Your teaching method is awsome .
I have started your Data analysis road map.
Awesome, all the very best 👍
@@RishabhMishraOfficial sir I have low configuration Pc, so I use exel 2007. Update version not support. Can I continue with my 2007 exel?
Sir ....aap kamal ho .....you r the one of the Best Teachers, Instructor, guide and so .....Huge Respect for you 🙏
Glad you liked the content ✅️
You are great and no 1 who made excellent projects . I learnt how to make dashboards on excel from u only and also sql from u and power bi ❤❤❤❤❤. Thanks for everything bhaiya . We are expecting lot from you . Please make combined projects like sql+ tabluea or sql + excel bhaiya
We want a combined project, related to mnc job profile. Those are realistic problems related to your daily work experience.🙏
Please help. How were you able to listen to the video in english? I don't understand his language. Please help. Thanks
Seriously You are God for me, so impressive. I started following you from yesterday You are giving me so much confidence to pursue.
You are genuine. God will bless you
Glad you liked it ✅️
Thank you Rishabh, for this SQL tutorial. You are doing great!! Your explanation gives quick idea to understand.👌
Glad it was helpful! ✅️
Great effort ❤❤❤ Incredible explaination❤❤ keep going sir❤❤❤
Glad you liked it ✅️
for mysql users this is the query
SELECT
Gender,
count(*) * 100.0 / (select count(*) from employee ) as ratio
FROM
Employee
GROUP BY
Gender;
another way:- SELECT
COUNT(CASE WHEN Gender = 'M' THEN 1 ELSE null END) * 100.0 / COUNT(*) AS MalePercentage ,
COUNT(CASE WHEN Gender = 'F' THEN 1 ELSE null END) * 100.0 / COUNT(*) AS FemalePercentage
FROM Employee;
Your Explanation is best and easy to understand for Beginners..............Thankyou So Much Sir😊🙏
Glad it was helpful ✅️
your's way of explanation is very nice.....
Really good 👍 thanks brother 👏👏
Glad you liked ✅️
Excellent video Bro....🔥🔥🔥🔥
Glad you liked ✅️
Thank you Rishabh , I started my Data Analyst journey 4 months back from your videos and its been monumental for me. I have a request to please make a demo video on " updating resume as per the job requirement" . I have been applying for DA job but getting rejections from everywhere. I think there's need of a change in the way I apply. Also, I got really happy to know that You are also an APS alumni.
Job mili?
Mili job?
Check how to update resume on days analytics on TH-cam
Got ur job or still looking for ?
85954O7987 Please help with the data analyst job
Om Shanti
Your teaching practice is good. But you explain with accounting situation just like receipt, payment, invoice, customer master, item master, employee master, account group master, in this validation, min. Max. Reorder level & save with text box feed.
Great ...waiting for advance level questions
Very soon..
Rishab Bhai Thank you so much for this ( Bohot saari Duaaye )
Glad you liked ✅️
Hi Rishabh,
Thanks a lot for this awesome video.
Will you please reply this-:
Alias doesn’t work with where clause ( I understand this reason ) then
Why Alias works with “Having Clause “ . Don’t understand clear reason behind this.
Thanks
Thank you rishab Bhai.. keep shining ❤
Congratulations for 100K subscribers
Thank you so much 😀 Shreeji 🙌
Keep learning n keep growing 🚀
Gr8 sir Thank you sir, because of you, I understood SQL very well.And I'm still learning SQL.
Glad it was helpful ✅️ keep learning n keep growing 🚀
@@RishabhMishraOfficial sir thoda sql me query h Maine apko instagram pr msg kiya h sir
great video bhaiya.....tons of thanks..
Please bring pyspark realtime project with problem statement .....
Glad you liked it ✅️ n noted
Most valuable video for career growth 📈
Glad you liked ✅️
Great efforts bhai🎉🎉🎉🎉🎉🎉🎉
Glad you liked it ✅️
It was great work brother. Thank You for the teach this. God Bless you
Glad it was helpful! ✅️
thank you Rishabh You are a great teacher for me
Q7(b)
select empname,project from employee as co
inner join employedetail as ed
on co.empid=ed.empid
Group By empname,project
it can be done by this method also
delete from employee where empid in (select empid from employee group by empid
having (count (*))>1); this query deletes all the records we should implement the query to delete duplicates and it should keep 1 record out of duplicates records.
for that we can use row_number()
Thaxn for this video sir🙏
Glad you liked ✅️
Sir, Good Morning...Thank you for all sql videos, im ur obedient student from odisha...Sir, question no 2(b) "filter" query is not working in mysql ..so, i have written like these lengthy process but it works... "select ((select count(empid) from employee where gender='M')*100)/(select count(empid) from employee) as male_ratio,
((select count(empid) from employee where gender='F')*100)/(select count(empid) from employee) as female_ratio;"
plz must reply 💝
This works.. awesome 👌
Hello Sir, @ 7:23 are you using joins in the Table? If Yes, then why u r not using Join word. is it bcoz of self join,we can go without mentioning Joins.
>>select E1.employeename, E2.city
From Employee E1,Employee E2
where E1.City=E2.city
Thanks for this amazing video with pure Content 💯 You are amazing ❤
Glad you liked ✅️
You are the best ❤❤
Glad you liked ✅️
Fantastic tutorial videos brother 🎉😊😊
Glad you liked ✅️
Good brain twisting questions. Helped me. Appreciate your efforts
Glad it was helpful ✅️
Bhaeya apke videos dekh kar sql and excel Sikh liya and 2 projects bhi bana diye, first of all thanks for that providing such valuable knowledge, but mujhe portfolio banana nahi aa raha, kya aap ekbar apne music sql project ka portfolio bana k dengey jab bhi aap k pass time ho.
Glad it was helpful ✅️
Okayy will make a detailed video on this ✅️
Hello sir apke guide se bht kch clear hua hai sir mai mba in business analytics kr rhi hubut mera background psychology graduate h but mai basic power bi, sql basic , basic paython or Excel janti hu mujhe Carrer kaise start krna chahiye data analytics me job mil payega yah fir business analytics se start krna shi hoga as a fresher
Best teacher, i would understand your teachings easily Alhamdulillah. I have watched and taken notes of your excel, sql and power bi videos. Waiting for python videos. You keep teaching and keep growing.
One more solution for finding Nth Salary Using Rank Method :
WITH cte AS(
SELECT *, RANK() OVER(ORDER BY salary DESC) FROM employee
ORDER BY salary DESC
)
SELECT * FROM cte
WHERE rank = N
Thanks bhai its really very helpful for me 😘😘
Glad you liked 👍
q7 a if there are duplicate values such as 2 arjun with same empid then both the data is being deleted . please look into it
Best video ever
Love you Guru ❤️
Glad you liked ✅️
Q. 7 b the easiest approach is
Select empname, project from employee inner join employeedetail on employee.empid = employeedetail.empid group by project having count (*) >1
Again , well explained 😀, great learning experience.
As a learner , i want (Leetcode 50 playlist) from you💥.
Please make it. ✌
Awesome, keep learning n keep growing 🚀
Awesome brother, i try watch your all vedio
Glad you liked the content ✅️
Keep learning n keep growing 🚀
Rishab very very thanks for taught us as a best Mentor👍👍🤝🤝🤪
Thanks and welcome ✅️
hi rishabh i have a doubt in hackerrank top eaner problem
the solution with worked is
select months * salary , count(employee_id) from employee
group by months * salary
order by months * salary desc
limit 1 ;
but i thought abt an alternate solution but it didnot worked
select months * salary , count(employee_id) from employee
where months * salary = (select max(months * salary) from employee);
in chatgpt they both are giving same result with multiple examples
can you tell me how these two are diffrent ?
23:00
select ((salary/100) || 'xx') as temp_salary
from employee
I was using SQL lite there's no option for concat
Thank you for this video. But please make some videos on power bi.
I'm glad you liked ✅️ there are already 3 videos on power bi, and you can watch them
@@RishabhMishraOfficial thank you sir for reply ☺️
Superb bro...
Glad you liked ✅️
Thanks for another SQL video 👍🏼👍🏼
Glad you liked ✅️
Really Rishabh you are best😊
Glad you liked the content ✅️
Sir video very helpful 👌👌🙏
Glad you found it helpful 👌
Hi sir
Sir video ki madat se bahut kuch revise ho gaya hai thank you sir😊😊
Glad you liked ✅️
Create one video on data modeling, also explain how to create dimension table if we have only fact tables
thanks for the video lecture. Too much useful and informative.
Glad it was helpful! ✅️
Rishabh bhaiya .. can you please provide other way for male: female ratio
Because sir Filter function only work with postgre SQL and SQL lite ...
It will not work with SQL server and oracle
You can use below example to solve this problem :
select sum(case when state = 'NY' then 1 else 0 end)
amazing video the last bonus question has been asked lately in obe the interviews.
Glad you liked it ✅️
congratulates 100k
Thank you so much brother 😀 🙌
Thanks Rishabh Brother !
Glad you liked ✅️
It's really good 👍 approach but I have still some doubts
Dear sir your question 7(b) if only two people in same project then it is ok but when 3 or more people in same project then it is not good approach to search people in same Project. Well, I am your Student and I really respect you and your Way of Teaching.
Yess this solution will be applicable in that case as well
Really love your content. Love you from Pakistan.
Glad you liked ✅️
First of all Thank you Mr. Rishabh to make this awesome & helpful video, please help me to resolve one doubt of question 4, where you used Emp.Rownumber % 2 = 0, my doubt is why did you use operater '%' instead of operator '/ ' thanks in advance , will wait for your reply
Sir, can you make this type of video for python as well
Yess noted ✅️
Damn! Learned a lot from this video. Thank you so much and you are doing great for all of us .
Glad you liked it ✅️
PLEASE!!! Make a Video On PowerBI Project
most helpfull video
Glad it helped ✅️
congats
close to 100k
Thank you so much Shekhar 🙂 it's all bcoz of everyone's love n support ❤️
@@RishabhMishraOfficial Thank Sir
I got confidence on SQL after watching your 2.5 hr sql tutorial video
Now I'm practicing SQL questions
@@RishabhMishraOfficial Sir
r u from Vrindavan
You always mentioning Names from Pastimes of Lord Krishna ❤
Thank You Sir...learning a lot from u
Glad you liked it ✅️
Thanks a lot for knowledgeable content keep rocking looking forward for more technology videos. SQL and power bi are the best
Glad you like them! 👍
Bhaiya no video since more than a month Waiting for more dhaansu content on SQL,Excel and Power BI
Thank u sir ❤❤❤
Glad you liked ✅️
@@RishabhMishraOfficial bhaiya please upload a project on SQL + excel if possible
I would like to request you, Please make video Power BI, SQL and Python for data analyst with project
Okayy noted ✅️
This is best sql interview video 👍👍✨✨
Glad you liked ✅️
💗💗
Sir aap ek nayi series start kijiye jisme Business Analyst ke sare modules cover ho jaye A-Z
Okayy noted ✅️.. waise tho business analyst k skills n resources same h data analyst k
@@RishabhMishraOfficial 🤌💗
Mose easiest way in MS SQL-select empname,stuff(salary,len(salary)-1,3,'XX') as masked_salary from employee
Thanks brother 🎉
Glad you liked ✅️
Thank you brother...i needed this video for my upcoming interviews 😊
ANSWER 1(b)................ (another approach)
Select empid, empname, gender, salary, city from (
select *, rank() over(partition by city ),
count(*) over(partition by city)
from employee) y
where y.count>1;
Thank you so much sir 🙏 🙏
Glad you liked ✅️
Thanks for ensuring that we have insert statement for hands on.
Glad it was helpful ✅️
Thank you very much bhaiya for easy video's like this. 😊🎉
Glad you liked ✅️
Superb bhai❤thnk u and expected more interview related questions basically am snowflake developer and job seeker pls help more bro
Q1(b): Write a query to retrieve the list of employees from the same city.
SELECT
city, GROUP_CONCAT(empname) as 'employees list'
FROM
employee
GROUP BY city
HAVING COUNT(1) > 1;
Thankyou Sir
Glad you liked ✅️
Hey Rishabh , really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .
Sir make one full video on what is needed to be cover on python,numpy,panda and important stuff
Okayy noted ✅️
Thank you sir 🙏❤
Glad you liked ✅️
Sir, please make video on data analytics interview questions for freshers
Okayy noted ✅️
Thanks. Sir ❤️❤️
Glad you liked ✅️
Thank you so much for your hard work 👍👍 and then helping us out.
Glad you liked ✅️