Interested to Buy Any Domain ? << Click Here >> for more details...
table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
- 7 Answers
- 10591 Views
- I also Faced
- E-Mail Answers
Answer Posted / suraj
-- create table #Employees (EID int, EName varchar(20), MID
int)
-- insert #Employees values(101,'Rama',NULL)
-- insert #Employees values(102,'Sita',101)
-- insert #Employees values(103,'Shiva',101)
-- insert #Employees values(104,'Ganesh',103)
--for 103 ID the manager ID is 101(RAMA) and for 104
manager is SIVA
--Write a script which displays Shiva's Manager's name.
select a.EID, a.EName, a.MID, b.EName
from #Employees a
inner join #Employees b on a.mid=b.eid and a.EName='Shiva'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is a dataset and what are the different types of datasets?
What is join and name different type of joins?
When we should use and scope of @@identity?
Can you explain different types of joins?
Can you roll back the ddl statement in a trigger?
In which tcp/ip port does sql server run? Can it be changed?
What is the use of @@spid?
Explain external key management in sql server 2008
How to link tables in sql server?
What are the different sql server versions?
What are logical database components? : SQL Server Architecture
How do I debug a stored procedure in sql server?
Explain logical operators in sql server?
Write an sql query to find first weekday of the month?
How to join two tables in a single query in ms sql server?
