Answer / ganesh

select column1, column 2, count('X') from Table_name
group by column1, column 2
having integer(count('X')) > 1

Answer / ramana99

select City, Country, count('X') from Customers
group by City, Country
HAVING count('X') > 1
;

B37 abend during spufi?

0 Answers   IBM,

---

Which catalog tables contain authorization information?

1 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

What is a base table?

2 Answers  

---

What do you mean by cursor?

0 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---

How is a typical db2 batch pgm executed?

0 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---