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
- 10322 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
How do I start sql server 2017?
What are character string data types in ms sql server?
What is the difference between row_number and dense_rank?
What is your recommendation for a query running very slow? : sql server database administration
Describe in brief sql server monitoring ways.
What is partition in sql server?
Explain left outer join and right outer join?
How to delete a login name in ms sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is transact-sql language?
Is BCNF better than 2NF & 3NF? Why?
Give me a SQL Query to find out the second largest company?
How to generate create function script on an existing function?
Difference between aggregate functions of sql?
What is scalar user-defined function?
