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
10288 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 is difference between joins and subqueries?

1094

What is the recursive stored procedure in sql server?

1003

How many tables can be joined in SQL Server?

1045

What is clustered index

989

What functions can a view be used to performed?

1050

Why do we backup Active Directory ?

1029

What is parameterized reports in ssrs ?

147

How to generate create table script on an existing table in ms sql server?

1132

Can sql servers linked to other servers?

1018

How to replace given values with null using nullif()?

969

What is SQL Server?

1191

What is the maximum number of index per table?

1052

What do you mean by a Composite primary key?

1084

What is the difference between NOROW and LOCKROW?

2817

What are the dmvs? : sql server database administration

1043