Answer Posted / anuj barthwal

A self join applies on one table only

Example:

emp_id emp_name emp_manager_id

1 Anuj NULL

2 Sunny 1

3 Suraj 1

4 Narban 2


if we want to get the name of the managers

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

manager employee

Anuj Sunny

Anuj Suraj

Sunny Narban


Self join means joining the single table to itself

I have a few records all are same structures data, I want to store data in multiple targets how

2708

---

What is the database development process?

1266

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2263

---

How you can make a parameterized view?

1069

---

Which data type cannot be used as a parameter in a udf?

1020

---

What is a database development?

1015

---

What are the types of database model?

1137

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2470

---

How to customize error conditions.

2197

---

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?

2470

---

Explain about the relational database?

1130

---

Where is dbms used?

1126

---

Explain about post-relational databases?

1078

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4053

---

fact table and dimension table containg one to many relationship or many to one relastionship

2548

---