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 / samba shiva reddy . m
this will also works for u change is id in inner join
select emp1.ename from employee emp1
inner join employee emp
on emp1.eid=emp.mid
where emp.eid=102
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is indexing in sql server with example?
What is implicit cursors?
How can we improve performance by using SQL Server profiler?
Do you know what are pages and extents? : SQL Server Architecture
What is sql server profiler trace data file?
What is tablesample?
What is the standby server?
What are the system database in sql server 2005?
What does indexation mean?
How to display a past time in days, hours and minutes?
How data can be copied from one table to another table?
What is nested transaction?
How to use go command in "sqlcmd"?
How do I uninstall sql server 2014?
What is inline variable assignment?