Answer / ramya

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)



INSERT INTO EMPLOYEE VALUES(101,'Mary',102)

INSERT INTO EMPLOYEE VALUES(102,'Ravi',NULL)

INSERT INTO EMPLOYEE VALUES(103,'Raj',102)

INSERT INTO EMPLOYEE VALUES(104,'Pete',103)

INSERT INTO EMPLOYEE VALUES(105,'Prasad',103)

INSERT INTO EMPLOYEE VALUES(106,'Ben',103)


select e1.employee_id,e1.name,e1.manager_id,e2.name from
employee e1 join employee e2
on e1.employee_id = e2.manager_id

Answer / mona

A table join to itself is known as self join.

select emp.ename,mngr.ename from emp.empl,emp.mngr where
emp.mngrno=mngr.empno

Answer / vijayan.t

A table join to itself is known as self join.


select e1.empid,e1.empname,e1.empmgrname where empmgrid =
empid;

here in a single table e1 having three fields(employee id,
employee name,manager id)one employee's manager id is
another one employee's employee id so compare that 2 ids and
we can get the particular employee's manager name...

Answer / pradeep sharma (http://www.tec

create table emp
(
empid int,
mgrid int,
empname varchar(50)
)
insert into emp values(1,2,'a')
insert into emp values(2,3,'b')
select * from emp

select e.empname as employee,d.empname as mgr from emp e
inner join emp d
on d.empid=e.mgrid

Answer / mike

You lost one Anju as Employee , because Anju does not have a
manager.
You should use left outer join in this case.

select e1.emp_name 'manager',e2.emp_name 'employee'
from employees e1 left outer join employees e2
on e1.emp_id=e2.emp_manager_id

Answer / nishant dubey

Table join itself using alias..
example
Select N,emp_id,N.emp_name,D.emp_id,D.emp_name from Nishant
N,Nishant D where N.emp_id=D.emp_id;

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

how to find the first two highest salaries in deptno in emp table

2 Answers  

What are the 18 schemas?

0 Answers  

In which database can extended stored procedures be added?

0 Answers  

Write the difference between case version and decode version.

2 Answers  

What is a self join? Explain it with an example?

16 Answers   TCS,

Explain about the relational database?

0 Answers  

How can you fix a poorly performing query?

0 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  

Can you instantiate a COM object by using T-SQL?

1 Answers