wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

What is a view? Why use it?

2 Answers  

---

what are extents?

5 Answers  

---

What is the physical storage length of time data type?

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

How to execute stored procedures?

0 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---

What is meant by explain?

0 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---