Declare @eid int Set @eid=2 select 'The manager for employee id &#

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 / saravanan p

7 Answers
10359 Views
I also Faced
E-Mail Answers

Answer Posted / saravanan p

Declare @eid int
Set @eid=2

select 'The manager for employee id '+convert(varchar
(50),e2.eid)+' is '+e1.ename from emp e1,emp e2
where e1.eid=e2.mid and e2.eid=@eid

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are triggers in ms sql server?

1160

What are null values in ms sql server?

1088

What is view in sql?

904

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

How real and float literal values are rounded?

1157

What are views used for?

1014

Can You Use Data Mining Models In Ssrs?

145

Explain the dirty pages?

1006

How can you stop stored procedures from recompiling?

900

What is a raid and what are different types of raid configurations?

1267

Define the one-to-one relationship while designing tables.

903

How we can compare two database data?

946

What is normalization 1nf 2nf 3nf?

1060

Can we insert data into view sql server?

927

Write query to return all rows sql?

1053