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
- 8272 Views
- I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
select emp.ename from employee emp1
inner join employee emp
on emp1.mid=emp.eid
where emp1.eid=102
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a linked server in sql server?
How to find which stored procedure is currently running in sql server?
Explain triggers in sql?
What is b tree index?
What are Spatial data types in SQL Server 2008
What guidelines should be followed to help minimize deadlocks?
What is the purpose of linked server configuration in sql server?
Is ssrs support other database except ms sql server?
What functions can a view be used to performed?
What are the different types of sub-queries?
Can you pass expressions to stored procedure parameters?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a derived table?
What sql server means?
List out some of the requirements to set up a sql server failover cluster?
