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 are data modelling techniques?

968

---

Explain the cube operator?

1010

---

What is the physical representation for a many-to-many relationship?

1077

---

Explain the process of the user request and data generating?

1094

---

How can you log an error to the server event log from a stored procedure?

1106

---

How to generate OIDS

2255

---

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

1119

---

How is data stored in dbms?

958

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1001

---

How to combine two function together?

2129

---

Explain about query and reporting.

2091

---

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

2531

---

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

2167

---

How can you fix a poorly performing query?

1186

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2029

---