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
- 10284 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 are the types of indexes? : Sql server database administration
What is equi join with example?
What happens when transaction log is full?
What is the difference between a "where" clause and a "having" clause?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What does man by sql wildcard characters in sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Explain what is the difference between a local and a global temporary table?
Explain the difference between control flow and data flow?
What is pivot and unpivot?
What are the essential components of sql server service broker?
Explain syntax for viewing trigger?
What are the types of processing and explain each? : sql server analysis services, ssas
How do you send email on SQL Server?
what types of replication are supported in sql server? : Sql server database administration
