Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 10287 Views
- I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
create table emp (eid int, ename varchar(50),mid int)
insert into emp values(1,'Ganesh',null)
insert into emp values(2,'Ramesh',1)
insert into emp values(3,'Suresh',1)
insert into emp values(4,'Selvam',2)
insert into emp values(5,'Vignesh',3)
select * from emp
Declare @eid int
Set @eid = 4 -- Your Input ID here..
Select 'Manager For '+CONVERT(VARCHAR,emp2.eid)+' --> '+ emp1.ename
From emp emp1
Inner join emp emp2 on emp1.eid = emp2.mid and emp2.eid = @eid
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is nested transaction?
How will you go about resolving deadlocks?
How to change parameter value inside the report?
What is the difference between a local and a global temporary table?
Define Wed Edition in SQL Azure?
‘Order by’ is not allowed in a view how can you sort information from a view?
What stored by the master?
What are the operating modes in which database mirroring runs?
Difference between uniqe index and uniqe constraint?
What different steps will a sql server developer take to secure sql server?
What is fill factor and pad index?
What do you mean by authentication modes in sql server?
Explain the ways to controlling cursor behavior?
What are the different subsets of sql?
What is a periodical index?
