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
10324 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

How to include text values in sql statements?

1027

What are page splits?

993

How to create a store procedure with encryption?

993

What is user defined stored procedures?

925

What are the elements of dbms?

955

Do you know what guidelines should be followed to help minimize deadlocks?

967

What is query parameter in ssrs?

160

What are the advantages of using a stored procedure?

1000

How to use group functions in the select clause in ms sql server?

1046

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1051

Differentiate between SQL and ORACLE joins and write their syntax.

1026

What is a database in ms sql server?

1050

What is 3nf normalization?

988

How do I find the sql server database version?

996

What is database dimension? : sql server analysis services, ssas

1069