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
;

What is filter factor?

2 Answers  

---

What is the database descriptor?

2 Answers  

---

What is meant by AUTO COMMIT?

3 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,

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

What is a trigger in the db2 database?

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

Are views updateable?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

Is db2 a database?

0 Answers  

---

What is dpf in db2?

0 Answers  

---