SQL Query To Fetch Employees Who Are Also Managers | Self Join Example | SQL Interview Question

[@crackconcepts]

Hi, there’s a small correction.
The condition should be
ON e.empid = m.man_id;

[@jktamizhangaming8875]

Do more videos mam

[@tanmaychoudhari7483]

Appreciate the efforts.
Your videos have helped me a lot.
But, it would be really helpful if you could edit the video or fetch in new one with the correction.
I am sure many people are not reading comments.
I got confused at first when you joined on emp_id on both ends.
Thank you Sadia

[@swapnilpatil4575]

yupp.

[@malaydubey3584]

What will be the count of rows if we have single column in both the table

[@debashishchoudhury9701]

Thanks Sadia, recreating the video will be more helpful as not everyone will be visiting the comment section. It may mislead them. Btw thanks a lot for all your videos. Very much helpful and easy to understand 😊

[@ritikkaushik2469]

Can we also use inner query like
select emp_id from employee where emp_id IN (select manager_id from employee);

[@srinivasgollapalli5961]

Your videos are like quick recaps for concepts , thank you

[@tejaswig1306]

your way of teaching is amazing. explaining using query helped me to understand the purpose. i have seen videos explaining self join but this really made me understand the purpose and how to use it.

[@UpendraYadav-te8ov]

Well explained, these videos are like revision to me thank you

[@trishjais]

Joining clause is wrong , it should be e.emp_id=m.mgr_id

[@IQBees]

We can use either IN or Exists as well to achieve the same

[@rajeevmayekar1775]

u make it easy good work as always

[@rejingunasekaran]

Awesome is your explanation

[@karthiknarayana2990]

Thanks alot for the knowledge you sharing and teaching sql concepts so simple but highly understandable. Appreciate your great effort.

[@usernameundefined9308]

Abe galat pada rakha h

[@pranjalimude8193]

Hey, the contents are too good.. just one suggestion, It would be great if write queries into details part, as sometime the query and the table details are not visible.

[@vithyalakshmikr6622]

I have a question: How to display no of 'L' in each name? Like counting the char in name using SQL query

[@pavansai4159]

Transfer the employees from department 10 to 20?
Which syntax we can at this place

[@riteshchaudhary9776]

it should be e.empid=m.managerid.

[@subratakumarmohanty7041]

Please do some videos on real-time related query

[@ATOZSTUDYWITHMYK]

U r so good Sadiya Appi.....

[@tonnykshatriyas6292]

HI, I GOT A ERROR LIKE Ambiguous column name 'CITY'. CAN YOU HELP ME WITH IT?

[@anonymouslifestyle666]

inner join should be on man_id not with empid itself

[@rajeshjs883]

Hi do you conduct sql classes.. On scenarios based plz do let m know.

[@lolipops8503]

thanks so much!

[@vamsi6421]

Mam could u pls say the output after that query?

[@ChaitanyaKondaveeti]

Who are mangers or who are also managers? I think who are mangers from the employee table

[@shadabakhtar9038]

I mailed you one problem statement, Can you make a video on the same.

[@RaviKumar-lg9qp]

I have two tables both have same records but in one table for no records inserted blank values but for another table no records, inserted null values which is okay . How can compare both tables and considering black values are equivalent to null values respectively

[@IQBees]

Use ISNULL(ColumnName,'') to compare

[@dramaworld3213]

And database Ko secure kaisa rkha jay k wo crash na ho

[@sahilbhatia2671]

Another way of doing it
Select emp_id from employee
Where emp_id in (select distinct man_id from employee)

[@trishjais]

This will create issue where mgr_id is null

[@sahilbhatia2671]

@@trishjais i dont think so because we can have null values in the list but it wont effect in statement

[@trishjais]

@@sahilbhatia2671 i meant if you were to find the employees who are not manager with not in statement, then it will not give you the correct result, try it yourself

[@swapnilpatil4575]

all videos are easy and simple to understand..good work.

[@sivakumarpandaram]

Super

[@Sandeeeep.youtube]

Great I like your consistency in uploading video

[@abhaytyagi7093]

Hi.. I have a doubt.. like how to find the last employee who joined company before a given date say 10/01/21..

[@BHARATHEEYUDU.]

Use between operator

[@abhaytyagi7093]

@@BHARATHEEYUDU. that's not possible.. I don't have a interval of dates to use between.. I just want to find who was the last joinee.. there can be more thn one employees joined on same date.. I need the last one

[@IQBees]

Filter record in where clause
Where Joining Date < Given Date
Then use order by on your identity column in desc order.
Select Top 1 * from employee
Where joiningdate < givendate
Order by employeeid desc

[@abhaytyagi7093]

@@IQBees that sounds right 👍

[@amitkumarswengineer5004]

Good

[@sachinr3823]

Hi madam, can you please able to provide all notes scanned pdf

[@abhi1994100]

easiest solution found so far

[@dramaworld3213]

Miss Kiya ap notes provide kr sakti h sql k urdu m i will pay you

[@badruddindulvi4819]

E.EmpId=M.Man_id right ?

[@rahulkalindi2072]

select empid from employees where empid=man_id; ( without self join )

[@darkestknight1260]

Select * from employee where emp_id = man_id ?
Is it right or not

[@mohanmurali4138]

Nope..Its not correct..That will give you no result unless an employee is manager to himself..

[@darkestknight1260]

@@mohanmurali4138 we have to fetch the employee who is manager then how it is wrong

[@sangeetasangeeta1926]

How to add new column at specific position

[@IQBees]

ALTER TABLE by default adds new columns at the end of the table. Use the AFTER directive to place it in a certain position within the table:

[@masthanjinostra2981]

Bro/sis :- consider table as employee!!!!
If there is column place and district,in between if we need to add column “city” in between “place” and “district” use following:-
_____________________
alter table employee add city varchar(30) after place;
__________________
if we use:-
__________________
alter table employee add age int ;
__________________
Will add in last position.
to change column name place to places
_______________________
alter table employee change place places varchar(30);
_______________________
Sorry if it’s wrong 😑

[@AdilKhan-nl1yu]

Your explanation is awesome

[@tejasbachhav2831]

I found this video in recommendation.
I think I have found gold 💜

[@sharmilaahmed]

Actually.....I am only in grade 7 so I don’t need to watch these....
But I still viewed all your videos cause of your voice....so cute 😘😘