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

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
10327 Views
I also Faced
E-Mail Answers

Answer Posted / samba shiva reddy . m

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is it’s similarity with sql server?

160

Explain about sql server login?

1073

mention different types of relationships in the dbms?

1009

Tell me what is the difference between locking and multi-versioning?

1019

how you can list all the tables in a database?

1020

How to loop through result set objects using mssql_fetch_array()?

1065

Explain sql server authentication modes?

1119

What is the most common type of join?

984

How to rename an existing column with sql server management studio?

991

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

972

Equi join and non equi join is possible with sql server?

1009

Detail about query optimizer?

1090

What is mssql?

980

What is "scheduled jobs" or "scheduled tasks"?

970

What does the not null constraint do?

1070