Answer / guest

C) SUM, MAX, AVG , MIN &COUNT

Answer / ramakrishna nattam

c

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What are the three types of page locks that can be held?

1 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is runstats db2?

0 Answers  

---

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 resolve deadlock issue

5 Answers   IBM,

---

What is cursor?

2 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

Explain about mirror activator disk mirroring?

0 Answers  

---