Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10368 Views
- I also Faced
- E-Mail Answers
Answer Posted / suraj
-- create table #Employees (EID int, EName varchar(20), MID
int)
-- insert #Employees values(101,'Rama',NULL)
-- insert #Employees values(102,'Sita',101)
-- insert #Employees values(103,'Shiva',101)
-- insert #Employees values(104,'Ganesh',103)
--for 103 ID the manager ID is 101(RAMA) and for 104
manager is SIVA
--Write a script which displays Shiva's Manager's name.
select a.EID, a.EName, a.MID, b.EName
from #Employees a
inner join #Employees b on a.mid=b.eid and a.EName='Shiva'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to optimize stored procedures in sql server?
what protocol both networks use? : Sql server database administration
can SSRS reports Cache results?
what is create database syntax? : Sql server database administration
Explain about remote stored procedure?
How to create stored procedures with parameters in ms sql server?
Does any body please help me what question's have asked for SSRS in the interview?
Explain having clause and where clause?
How many types of triggers are there?
What are approximate numeric data types in ms sql server?
Explain few examples of RDBMS?
How can you append an identity column to a temporary table?
List types of tables in SQL Azure?
What is a system database and what is a user database?
What is similarity and difference between truncate and delete in sql?
