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
10595 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 is the difference between functions and scalar functions?

1285

What is a select query statement in ms sql server?

1132

How to connect php with different port numbers?

1149

Difference between 2NF &3NF ?

1132

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1099

what are the Prerequisites for Replication?

11445

What are statistics?

1053

Explain what is sql server english query?

1109

Does order by actually change the order of the data in the tables or does it just change the output?

1208

What are commit and rollback in sql?

1170

How can you insert null values in a column while inserting the data?

1343

How to create a view on an existing table in ms sql server?

1194

Define left outer join?

1028

When is update_statistics command used?

1089