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
- 10101 Views
- I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
create table emp (eid int, ename varchar(50),mid int)
insert into emp values(1,'Ganesh',null)
insert into emp values(2,'Ramesh',1)
insert into emp values(3,'Suresh',1)
insert into emp values(4,'Selvam',2)
insert into emp values(5,'Vignesh',3)
select * from emp
Declare @eid int
Set @eid = 4 -- Your Input ID here..
Select 'Manager For '+CONVERT(VARCHAR,emp2.eid)+' --> '+ emp1.ename
From emp emp1
Inner join emp emp2 on emp1.eid = emp2.mid and emp2.eid = @eid
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is self join in sql server joins?
How many databases can we create in a single server?
What is global temp table?
Can a table have 2 foreign keys?
Is it possible to replicate data from sql server to oracle? : sql server replication
Explain the disadvantages of cursors?
What is after dml trigger?
How you provide security to cube? : sql server analysis services, ssas
How to encrypt Strored Procedure in SQL SERVER?
What are wait types?
Explain hostprotectionattribute in sql server 2005?
Define Business Edition in SQL Azure?
Tell me the phases a transaction has to undergo?
How to check if a table is being used in sql server?
what is a transaction? : Sql server database administration
