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;

Explain what a database is?

1036

---

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

2643

---

Write the fastest query to find out how many rows exist in a table?

1109

---

How can I detect whether a given connection is blocked?

1048

---

Explain the role of indexing in databases?

1120

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

958

---

Explain about query and reporting.

2081

---

How you can make a parameterized view?

1007

---

In which table collections errors are stored.

2405

---

Explain about a primary key?

978

---

Where is dbms used?

1069

---

explain detail about ftp in datastage?

2240

---

Explain about relational operator join?

1033

---

Explain about post-relational databases?

1016

---

Can an extended stored procedure be called from inside a user-defined function?

1049

---