Answer Posted / madhavi

Joining the table to itself is self join.
Example:

To find the manager name for each employee in the employee
table:
select e1.empno employee_id,e1.ename employee_name,e2.ename
manager_name,e2.empno employee_num from emp e1,emp e2 where
e1.empno=e2.mgr;

What is DB Development software?

1997

---

What is dbms explain in brief?

953

---

How to combine two function together?

2056

---

Write short notes on manual refreshes.

2676

---

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

2440

---

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

2098

---

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

904

---

Explain what a database is?

975

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

944

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

947

---

Explain about the relational database?

991

---

In which database can extended stored procedures be added?

852

---

What are the types of database model?

1023

---

Where is dbms used?

1009

---

Explain the process of the user request and data generating?

1027

---