Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What is host variable in db2 cobol?

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

---

Who uses db2?

0 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

How does a cursor work?

0 Answers  

---

Can one database have multiple instances?

0 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---