Interview SQL Query On Joins | Campus Preparation | Solve Any SQL Query | JOINS

In this video we will solve 4 SQL Query based on JOINS which are the very important for interview preparation .if you will solve these queries then you can easily solve any other query based on JOINS .
Here we will also discuss UNIVERSAL 3 STEP FORMULA for solve join based query.

⭐Difference Between WHERE and HAVING Clause

⭐Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )

⭐Use Of GROUP BY Clause In SQL

⭐SQL Joins & Its Types | INNER,LEFT,RIGHT,FULL,SELF,NATURAL

⭐Find the number of Employees working in each department | SQL

⭐Part 1:Top 9 SQL queries for interview -

⭐Part 2:Top 9 SQL queries for interview -

⭐Top SQL Interview Question

⭐SQL Query To Swap Value Of Male and Female In Single Statement

⭐Difference Between DELETE, DROP and TRUNCATE

⭐Constraints In SQL | Part-I

⭐Constraints In SQL | Part-II

⭐Wipro Interview Experience | Selected

⭐Infosys Interview Experience | Selected

#sqljoins
#sqlquery
#mysqltutorial
#sqlinterviewquestionsandanswers
#sqlinterviewquestion
#mysql
#sql
#oracle
#joins
#interviewpreparation

[sohailsmd]

You are teaching joins facts that you never explained why are we using left and right joins great teaching👍

[pratig]

You should explain why you choose left join

[alivia_ansari]

Watched this video for revision before my interview. Luckily the interviewer asked many questions from SQL and I had to write down the queries. This really helped 😍❤️

[BobbeeSingh]

Why a left join for 1st 3 queries and not an inner join? Explaining why left join and inner joins were used would have been helpful.

[Priyanka-qkd]

In query 3 can we change the order of manager and employee like. Can we write manager first and employee second? Please answer.

[vijaykumar.m]

very thank you madam
i cant understand while my madam teaching in class
now i can understand

[madhukareppalapelly]

in query 2...we have to write dept_id in select statement when we write group by class using dept_id

[MrTejasreddy]

u r explanation is really simple and clear..but if u provied data for practice for beginner then its very helpfull to them ...anyway gud explanation..keep it up...😊

[aryanshinde]

Mam 3rd query we can use natural join through joining two tables

[sandipwaghmare]

#Thank you shoo much the way of explaining topic is great within a half hour i have learn lot ☺️

[beingrishi]

Can you share the table schema in description box

[Priyanka-qkd]

I think there is no need of group by clause in first query

[neeshakumarisinha]

For the first question the Having clause seems incorrect. It should be HAVING COUNT(e.emp_id) > 2 to fetch the number of employees greater than 2 from each department.

[manojkumarrajaka]

I subscribed ur channel without watching this video. Bcz I assume that it will be helpful for me. Tq.
And joined in ur telegram group too

[akshaykumarrai]

How I will come to know which should be the left column here ? I mean for example you fetched two columns from employees why not from department ?

[crictune]

The column you taken after group by clause, it should be there in select statement too🙏,
I have wasted hour in finding it out as I am beginnet

[aryanshinde]

Mam why should be use left join we can also use inner join throught join the 2 or more table

[sudhanshupathak]

In the second one in place of e.dept_id it will come e._dept_name with group by

[ejntlkq]

thanks a lot saloni. it was really helpful appreciate the hard work keep going!!!!

[PandeyJii]

Why to use left join for emp and manager to be from same city. We can simply use Join or Inner join.
e.empid= m.magerid will be correct as we shud have emp ID in employee table