@@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 🔥🔥🔥
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
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 🙏
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.
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
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.
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
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 🙏
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
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.
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
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
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
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.
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;"
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.
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.
Q2(b): What’s the male and female employees ratio. with cte1 as ( select count(*) as male_cnt from employee where gender='M' ), cte2 as ( select count(*) as female_cnt from employee where gender='F' ), cte3 as ( select count(*) as tot_cnt from employee ) select ROUND(male_cnt/tot_cnt*100.0,2) as male_ratio, ROUND(female_cnt/tot_cnt*100.0,2) as female_ratio from cte1 join cte2 join cte3;
One more question .I face in interview Find employees with avg salary increase by 7% every year and populate the employee id when salary goes to 100 where avg salary of first record is 50
WITH RECURSIVE salary_increase AS ( SELECT employee_id, salary, hire_date, salary AS initial_salary, 1 AS year_count FROM employees WHERE salary = 50 -- Assuming initial salary is 50 UNION ALL SELECT e.employee_id, e.salary, e.hire_date, si.initial_salary, si.year_count + 1 FROM employees e JOIN salary_increase si ON e.employee_id = si.employee_id AND e.salary > si.salary * 1.07 -- 7% increase every year ) SELECT employee_id, initial_salary, salary, hire_date, year_count FROM salary_increase WHERE salary >= 100;
Q2(c): Write a query to fetch 50% records from the Employee table. Alternate solution to this question select * from employee limit ( select count(*) from employee ) / 2; Here subquery will give us the total number of records which will be divided by 2. And then we will use limit to give us the half of the records. So if there are total 20 records then 20/2 will be 10 and the query would limit the records to just 10 rows. Thank you for such a great video. Learned many new things 💯
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
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 ?
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....
Query to retrieve the list of employees working in same project. with cte as ( select a.empid,a.empname,b.project from employee a join employeedetail b on a.empid=b.empid ) select project,group_concat(empname) as emp_names from cte group by project having count(1)>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 .
Hello Rishabh Bhai, In Q. 7(A) While using delete query in mysql I used this query and I inserted same values again to create duplicate value. DELETE FROM EMPLOYEE WHERE EMPID IN ( SELECT EMPID FROM (SELECT * FROM EMPLOYEE ) AS TEMP_TABLE GROUP BY EMPID HAVING COUNT(*)>1 ) but this query deleted all the data . so how should I write query to delete only duplicate values.
Sir please answer de Mai. 12th pass hu Science maths kiya hu Kya mai data analysis kar sakta hu. Uske kaun kaun se software use hote hai woh bhi video mention Karo please 🙏🙏🙏🙏
Good content. However the solution to deleting duplicate rows seems incorrect. Your solution will delete all the employee data which has more than 1 row for an empid. We only want unique employees in the table and duplicated removed. We don't want to delete the whole empids which has duplicates. Correct solution would be I believe: delete from Employee where empid in ( select empid from ( select *, row_number() over (partition by empid order by empid) as rn from Employee) A where A.rn > 1) Correct me if I am wrong. Happy learning!!
Hii bhaiya ..Actually I just started learning SQL and I am just going with your SQL playlist. You have used postgre software in your videos. I just want to ask is there any difference in using different softwares and why did you choose postgre??...Please reply
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
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
can i use this query to find n highest salary With CTE as( SELECT *,row_number() over(order by salary desc) as sal FROM NAMES ) select * from CTE where sal=4
Hii rishabh I have completed excel python and sql But now I am very confused about math for data science.... How much I have to read , which topics, how much time should I give...... Don't know anything Statistics, probability, linear algebra, calculus and so onn.... I don't know where to start..... Please make a detailed video on it...... And if you read this comment then please let me know by your reply..... Thanks
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.
Thanks much. Would you please make video on Agile scrum, Project manager and Product manager. And roadmap for all these 3 jobs - Project Manager, Product manager and Scrum master.
2(b) solution: with x as (select cnt from (select count(*) as cnt,Gender from employee group by Gender) a where gender="m"), y as (select cnt from (select count(*) as cnt,Gender from employee group by Gender) a where gender="f") select concat(x.cnt,":",y.cnt) as male_female_ratio from x cross join y;
risabh great video like it ♥️, I want advise from you as you have been in Data Analyst field, I haven't been good with communication skills, Can I enter into the data Analyst field and Can I stay for long term in data analyst field without good communication skills, And is there any other channel to communicate through, Kindly give me advise on that, it will be helpful for me going into data analyst field Thanks
i got the result from this-- select t.empid,t.emp_name,t.project ,t.salary from(select t1.empid,t1.emp_name,t2.project,t1.salary, dense_rank() over(partition by t2.project order by t1.salary desc) as ranking from emp t1 join emp_d t2 on t1.empid = t2.empid) t where t.ranking =1;
i think this is the proper Answer of Question 7th B) select empname , project from ( select Empname , h.* from employees E join ( select * from employeedetail where project in ( select project from ( select * , row_number() over(partition by Project order by project ) as rn from employeedetail) a where rn > 1) ) h on e.empid = h.empid ) c order by project
Hi bro you're amazing....I have request for you.. that plz make video on Tableu so that many of students can learn easily...bcz as a non IT background I can understand your explanation so it is easy for us to learn Tableu from you
HI SIR Greetings I am learning sql from you i want to ask, is it possible to fill entire column values with a single command when there is a blank column with no values exists in a table Thank you
Hi Buddy, I don't satisfy with your delete query for duplicates. If you are just checking the Emp ID in IN clause it will delete both or more rows for that Emp ID. We should identify which row we need to delete and then delete that particular row. Thanks !
In question one the two queries will give different result in the condition where salary='200000' or salary='300000' because 'between' includes the end points
suppose I solved all of the question mentioned in this pdf without any external help (took some time though), will I be able to clear the SQL test for any company?
what will be the syntax of question (6) to finding the nth highest salary from employee table by using LIMIT/TOP keywards?? how to write syntax for this in mysql workbench???
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 🤞
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
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 🙏
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
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
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 ✅️
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
for mysql users this is the query
SELECT
Gender,
count(*) * 100.0 / (select count(*) from employee ) as ratio
FROM
Employee
GROUP BY
Gender;
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 🙏
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
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()
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
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
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
Great work Rishabh. You're the best. 100% trust in your work and efforts.
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
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 👌
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.
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 ✅️
Q2(b): What’s the male and female employees ratio.
with cte1 as
(
select
count(*) as male_cnt from employee
where gender='M'
),
cte2 as
(
select
count(*) as female_cnt from employee
where gender='F'
),
cte3 as
(
select
count(*) as tot_cnt from employee
)
select ROUND(male_cnt/tot_cnt*100.0,2) as male_ratio,
ROUND(female_cnt/tot_cnt*100.0,2) as female_ratio
from cte1
join cte2
join cte3;
Mose easiest way in MS SQL-select empname,stuff(salary,len(salary)-1,3,'XX') as masked_salary from employee
One more question .I face in interview
Find employees with avg salary increase by 7% every year and populate the employee id when salary goes to 100 where avg salary of first record is 50
WITH RECURSIVE salary_increase AS (
SELECT
employee_id,
salary,
hire_date,
salary AS initial_salary,
1 AS year_count
FROM
employees
WHERE
salary = 50 -- Assuming initial salary is 50
UNION ALL
SELECT
e.employee_id,
e.salary,
e.hire_date,
si.initial_salary,
si.year_count + 1
FROM
employees e
JOIN
salary_increase si ON e.employee_id = si.employee_id
AND e.salary > si.salary * 1.07 -- 7% increase every year
)
SELECT
employee_id,
initial_salary,
salary,
hire_date,
year_count
FROM
salary_increase
WHERE
salary >= 100;
Q2(c): Write a query to fetch 50% records from the Employee table.
Alternate solution to this question
select * from employee limit (
select count(*) from employee
) / 2;
Here subquery will give us the total number of records which will be divided by 2. And then we will use limit to give us the half of the records. So if there are total 20 records then 20/2 will be 10 and the query would limit the records to just 10 rows.
Thank you for such a great video. Learned many new things 💯
Glad you liked ✅️
it is not working
@@vazahatqureshi4910 what is the error ?? also tell me the DBMS which you are using. Is it MS SQL Server, Mysql or something else
You are genuine. God will bless you
Glad you liked it ✅️
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)
💗💗
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 🤌💗
your's way of explanation is very nice.....
Q no. 2 hum group by se bhi solve kar sakte hai na ? group by city and employee k name aa jayege through string_agg se and count >1
Check if u r getting same output
Thank you Rishabh, for this SQL tutorial. You are doing great!! Your explanation gives quick idea to understand.👌
Glad it was helpful! ✅️
Best sql qna video, was waiting for this video ❤❤🙏🙏
Glad you liked it ✅️
This is best SQL questions video 👍
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 ?
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....
Query to retrieve the list of employees working in same project.
with cte as
(
select a.empid,a.empname,b.project
from employee a
join employeedetail b
on a.empid=b.empid
)
select project,group_concat(empname) as emp_names
from cte
group by project
having count(1)>1;
I would like to request you, Please make video Power BI, SQL and Python for data analyst with project
Okayy noted ✅️
Seriously You are God for me, so impressive. I started following you from yesterday You are giving me so much confidence to pursue.
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;
Your Explanation is best and easy to understand for Beginners..............Thankyou So Much Sir😊🙏
Glad it was helpful ✅️
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 .
Rishab Bhai Thank you so much for this ( Bohot saari Duaaye )
Glad you liked ✅️
Hello Rishabh Bhai,
In Q. 7(A) While using delete query in mysql I used this query and I inserted same values again to create duplicate value.
DELETE FROM EMPLOYEE
WHERE EMPID IN
(
SELECT EMPID FROM (SELECT * FROM EMPLOYEE ) AS TEMP_TABLE
GROUP BY EMPID
HAVING COUNT(*)>1
)
but this query deleted all the data .
so how should I write query to delete only duplicate values.
you need to use ROW_NUMBER window function and partition by to remove duplicate records
Bhaiya bs ek chiz solve krdijye sql me kya kya topics cover krle ki Data Analyst me problem ni hga
Okayy will make a quick detailed video on this
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
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
Hi , Bhaiya I want to become to Data Analyst but I've no experience in coding, what should I start with ? SQL or Python?!Please guide me..
Sir please answer de
Mai. 12th pass hu
Science maths kiya hu
Kya mai data analysis kar sakta hu.
Uske kaun kaun se software use hote hai woh bhi video mention Karo please 🙏🙏🙏🙏
Sare questions k answers ek video mei hai- Data Analyst Roadmap. Iss video ko dekho
Nice one, do you have any session to install db in windows or macos system for practice?
Yes, already uploaded a video on how to download n install postgre sql
Good content. However the solution to deleting duplicate rows seems incorrect. Your solution will delete all the employee data which has more than 1 row for an empid. We only want unique employees in the table and duplicated removed. We don't want to delete the whole empids which has duplicates.
Correct solution would be I believe:
delete from Employee
where empid in (
select empid from (
select *, row_number() over (partition by empid order by empid) as rn from Employee) A
where A.rn > 1)
Correct me if I am wrong. Happy learning!!
Hii bhaiya ..Actually I just started learning SQL and I am just going with your SQL playlist. You have used postgre software in your videos. I just want to ask is there any difference in using different softwares and why did you choose postgre??...Please reply
Most of the databases use almost the same syntax, but i prefer postgre sql as it is used by most companies
Isn't MySQL used by most companies? Should I learn that or not?
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
great video bhaiya.....tons of thanks..
Please bring pyspark realtime project with problem statement .....
Glad you liked it ✅️ n noted
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
Sir, can you make this type of video for python as well
Yess noted ✅️
most helpfull video
Glad it helped ✅️
can i use this query to find n highest salary
With CTE as(
SELECT *,row_number() over(order by salary desc) as sal FROM NAMES
)
select * from CTE where sal=4
Thankyou Sir
Glad you liked ✅️
Hii rishabh
I have completed excel python and sql
But now I am very confused about math for data science....
How much I have to read , which topics, how much time should I give...... Don't know anything
Statistics, probability, linear algebra, calculus and so onn....
I don't know where to start.....
Please make a detailed video on it...... And if you read this comment then please let me know by your reply..... Thanks
thank you Rishabh You are a great teacher for me
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.
It was great work brother. Thank You for the teach this. God Bless you
Glad it was helpful! ✅️
Thanks much. Would you please make video on Agile scrum, Project manager and Product manager. And roadmap for all these 3 jobs - Project Manager, Product manager and Scrum master.
Okayy noted ✅️
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 ☺️
Great ...waiting for advance level questions
Very soon..
Sir make one full video on what is needed to be cover on python,numpy,panda and important stuff
Okayy noted ✅️
Most valuable video for career growth 📈
Glad you liked ✅️
bhai Your explanation is mind-blowing I did never thought like this thank you bhai
2(b) solution: with x as (select cnt from (select count(*) as cnt,Gender from employee group by Gender) a where gender="m"),
y as (select cnt from (select count(*) as cnt,Gender from employee group by Gender) a where gender="f")
select concat(x.cnt,":",y.cnt) as male_female_ratio from x
cross join y;
Really good 👍 thanks brother 👏👏
Glad you liked ✅️
risabh great video like it ♥️, I want advise from you as you have been in Data Analyst field, I haven't been good with communication skills, Can I enter into the data Analyst field and Can I stay for long term in data analyst field without good communication skills, And is there any other channel to communicate through, Kindly give me advise on that, it will be helpful for me going into data analyst field Thanks
More you practice the Communication skills more it will get improved. To get a job u just need basic Communication skill
Thanks Rishabh Brother !
Glad you liked ✅️
i got the result from this--
select t.empid,t.emp_name,t.project ,t.salary
from(select t1.empid,t1.emp_name,t2.project,t1.salary,
dense_rank() over(partition by t2.project order by t1.salary desc) as ranking
from emp t1
join emp_d t2
on t1.empid = t2.empid) t
where t.ranking =1;
Awesome 👌
Thanks for ensuring that we have insert statement for hands on.
Glad it was helpful ✅️
Good brain twisting questions. Helped me. Appreciate your efforts
Glad it was helpful ✅️
How do you use the sum, join the group by, and order by function in SQL in 1 command will you give some examples?
Sir, please make video on data analytics interview questions for freshers
Okayy noted ✅️
Can you make video on advance topics of SQL like crosstab and cast
Okayy
how to run select * from EmpDetails query because their data time format is DD-MM-YY but in PostgreSQL, it accepts YY-MM-DD format.
You can change the date format in sql
thanks for the video lecture. Too much useful and informative.
Glad it was helpful! ✅️
amazing video the last bonus question has been asked lately in obe the interviews.
Glad you liked it ✅️
Hi Dada,
Which tool you are using for hands on? please tell me
Using Postgre sql
i think this is the proper Answer of Question 7th B)
select empname , project from (
select Empname , h.* from employees E join (
select * from employeedetail where project in (
select project from (
select * , row_number() over(partition by Project order by project ) as rn from employeedetail) a where
rn > 1) ) h on e.empid = h.empid ) c order by project
Is the work you do in your job is as same as you show on the youtube videos or it's more complex and hard?? Waiting for the reply
It all depends on data u work on. Complex or unstructured data then it will be tough to work on it.
@@RishabhMishraOfficial Thank you so much for the best content and reply ! 😊
Hi bro you're amazing....I have request for you.. that plz make video on Tableu so that many of students can learn easily...bcz as a non IT background I can understand your explanation so it is easy for us to learn Tableu from you
Yess soon 🙌
@@RishabhMishraOfficial bro💎
Sir, some of the query not work in Mysql, like gender ratio and substring, especially casting. Did MySQL and postgres sql are different?
Yes both are different database, watch full video n you will get the answer
HI SIR Greetings I am learning sql from you i want to ask, is it possible to fill entire column values with a single command when there is a blank column with no values exists in a table Thank you
Yes, you can. Use update statement
thank you sir !@@RishabhMishraOfficial
Great effort ❤❤❤ Incredible explaination❤❤ keep going sir❤❤❤
Glad you liked it ✅️
23:00
select ((salary/100) || 'xx') as temp_salary
from employee
I was using SQL lite there's no option for concat
Sir agar koi koi company hire kar rahi hai based on sql skill to us par bhi video banana
Hi Buddy,
I don't satisfy with your delete query for duplicates. If you are just checking the Emp ID in IN clause it will delete both or more rows for that Emp ID. We should identify which row we need to delete and then delete that particular row.
Thanks !
This point is already mentioned in video, but anyways thanks for commenting 👍
In question one the two queries will give different result in the condition where salary='200000' or salary='300000' because 'between' includes the end points
Yess right ✅️
suppose I solved all of the question mentioned in this pdf without any external help (took some time though), will I be able to clear the SQL test for any company?
As a fresher, yess
@@RishabhMishraOfficial thanks a lot,..😁
It's really good 👍 approach but I have still some doubts
🙏 Make a video on end to end data analyst work/project Full process From A to Z
Okayy noted ✅️
Awesome brother, i try watch your all vedio
Glad you liked the content ✅️
Keep learning n keep growing 🚀
Hi Rishabh. Thanks for the wonderful content. Can I use the music project on SQL in my CV with the same questions?
Yes, absolutely 💯
@@RishabhMishraOfficial Thanks a lot
what will be the syntax of question (6) to finding the nth highest salary from employee table by using LIMIT/TOP keywards??
how to write syntax for this in mysql workbench???
@RishabhMishraOfficial
Please make video on pgadmin4 DBMS tutorial
Thank you rishab Bhai.. keep shining ❤
PLEASE!!! Make a Video On PowerBI Project