select ename from employee where eid = (select case mid when null then a

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

Question Posted / mohana krishna

7 Answers
10090 Views
I also Faced
E-Mail Answers

Answer Posted / mohana krishna

select ename from employee
where eid = (select case mid when null then aid
else mid end mid
where eid=@aid
)

select m.name from employee e
join employee m on (m.aid=e.mid)

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What to perform pattern match with the like operator?

837

What are the joins in sql server? : sql server database administration

961

How to connect Azure federated root database and apply federation in entity framework?

107

What are temporal tables in sql server 2016?

838

What are cursors stored procedures and triggers?

933

What is the stuff and how does it differ from the replace function?

1000

What are “phantom rows”?

1607

Can primary key be null?

878

application server is slow what may be the problem

2164

How to check table values in sql server?

908

Can we use where and having clause together?

977

How to verify a login name with sqlcmd tool?

1131

How to insert and update data into a table with "insert" and "update" statements?

914

Explain filestream storage of sql server 2008?

948

What are the benefits of normalization?

1044