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
- 10100 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
What are parameterized reports? What are cascading parameters in ssrs reports?
How to get a list of all tables with "sys.tables" view in ms sql server?
What type of Index will get created after executing the above statement?
What is sql sandbox in sql server?
Who is the owner of a schema in ms sql server?
What do you understand by a stored procedure?
What are dml (data manipulation language) statements in ms sql server?
Explain user defined functions?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are the functions in sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is normalization process?
What is the importance of a recovery model?
What is the purpose of optimization?
How to configure and test odbc dsn settings?
