He has given table attributes- empid,empfirstname,emplastname,MangerID.And he a

He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?

Question Posted / nandini p

3 Answers
7416 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

He has given table attributes- empid,empfirstname,emplastname,MangerID.And he asked write query to..

Answer / naveen kamatam

select a.employee_id,a.first_name,a.manager_id,b.first_name
from test a inner join test b
on a.manager_id=b.employee_id order by 1

Is This Answer Correct ?

4 Yes

0 No

He has given table attributes- empid,empfirstname,emplastname,MangerID.And he asked write query to..

Answer / nandini p

For that you can use self join.
With in organization you will get manager name and their
mangers name, entire chain if you know the mangerid.

Is This Answer Correct ?

1 Yes

0 No

He has given table attributes- empid,empfirstname,emplastname,MangerID.And he asked write query to..

Answer / sneha.va

Suppose 2 tables;
Employee : having columns
empid,empfirstname,emplastname,MangerID
Manager : ManagerID, Managername

SELECT A.EMPFIRSTNAME,B.MANAGERNAME FROM EMPLOYEE A INNER
JOIN MANAGER B
ON A.MangerID = B.MangerID

Is This Answer Correct ?

3 Yes

2 No

Post New Answer