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,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is the difference between drop table and delete table?

0 Answers  

---

What is db2 look?

0 Answers  

---

What is copy pending status in db2?

0 Answers  

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

How do you check for a null value in a db2 column?

2 Answers  

---

What are the contents of dclgen?

0 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---