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
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
When does a workload on SQL Azure get throttled?
What is primary key index?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Explain different types of locks in sql server.
What are information schema views?
How can we improve performance by using SQL Server profiler?
What new data source types were added in ssrs 2014?
Explain transaction isolation levels in sql server?
Explain differences between web edition and business edition?
How to verify a user name with sqlcmd tool?
What is transactional replication?
What is partitioned view?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Do you know the cursor types?
How to install sql server 2005 express edition?