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
- 10092 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
Explain about temporary stored procedure?
What is the difference between the application object and session object?
How to create median function?
What is tempdb in sql server?
What does the update command do?
Explain different types of lock modes in sql server 2000?
What is sql server profiler?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Define ACID properties in a Database?
What do you understand by replication in sql server?
What is a primary index?
what is an index? : Sql server database administration
What are the tools available in market as an alternative to sql server reporting services?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is snapshot parameter in ssrs?
