this will also works for u change is id in inner join select emp1.ename

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 / samba shiva reddy . m

7 Answers
10286 Views
I also Faced
E-Mail Answers

Answer Posted / samba shiva reddy . m

this will also works for u change is id in inner join

select emp1.ename from employee emp1
inner join employee emp
on emp1.eid=emp.mid
where emp.eid=102

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is relationship? What number of sorts of relationship are there?

1110

How to insert multiple rows with one insert statement in ms sql server?

1103

What is executereader?

932

What is after dml trigger?

992

What is side by side migration in sql server?

1078

Explain mixed authentication mode of sql server?

1032

how can you attach more than 20 ldf files in sql server

1985

What is sql stored procedure?

1062

Write a sql query to sort on different column name according to the parameters passed in the function?

880

What are data files?

1024

What new changes are being made in SQL Server?

1159

How does normalization work?

902

what are triggers? : Sql server database administration

892

Explain raiserror in sql server?

997

How do you clear a log file?

1031