OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

How to get the ddl of a table in db2?

0 Answers  

---

What is isolation level?

4 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

What is the physical storage length of time data type?

0 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

Is the primary key a clustered index?

0 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

What is package versioning? Please give an example.

1 Answers  

---