create table emp (eid int, ename varchar(50),mid int) insert into emp va

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

Question Posted / soorai ganesh

7 Answers
10328 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

Please Help Members By Posting Answers For Below Questions

What are the difference between “where” and “having” clause in sql server?

1061

What is the use of group by clause?

935

Can we use where clause in union?

1058

Explain microsoft sql server functions?

1099

How do I partition a table in sql server?

1029

What is the difference between update lock and exclusive lock?

969

Explain an incremental backup?

992

What are the Advantages of using CTE in sql server?

1106

What are sub reports?

201

How to copy the tables, schema and views from one sql server to another?

1038

What is the purpose of floor function?

1027

Explain transaction server auto commit?

1029

Explain having clause?

955

What happens if null values are involved in bitwise operations?

1008

Explain what is the use of custom fields in report?

910