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
- 10363 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohana krishna
create table #emp (eid int, ename varchar(50),mid int)
insert into #emp values(1,'Ganesh',null)
insert into #emp values(2,'Ramesh',1)
insert into #emp values(3,'Suresh',1)
insert into #emp values(4,'Selvam',2)
insert into #emp values(5,'Vignesh',3)
declare @aid int
set @aid =1
select ename from #emp
where eid = (select case isnull(mid,0) when 0 then eid
else mid end mid
from #emp
where eid=@aid
)
select m.ename from #emp e
join #emp m on (m.eid=isnull(e.mid,e.eid))
where e.eid=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does hive support indexing?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is statement level trigger?
Explain cdc and sql injection?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How to get the definition of a stored procedure back?
Explain what are the authentication modes in sql server?
How to turn on the mssql api module in php?
What stored by the master?
What happens when the SQL Azure database reaches Max Size?
What is merge statement?
Can you explain what are various ways to enhance the ssrs report?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the difference between locking and multi-versioning?
How do I start sql server 2016?
