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
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
What is a heap?
What is a cursor, index in sql?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Explain about sql server login?
What are the recovery models in sql server 2000?
What is the difference between clustered index and primary key?
How to turn on the mssql api module in php?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
 Explain what is sql override for a source taLle in a mapping?
What is the difference between set and select?
How to download and install microsoft .net framework version 2.0?
Which language rdl files made of?
How do you check sql server is up and running?
What is Service Broker in sql server 2012?