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
;

Describe what a storage group(STOGROUP) is?

2 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

What does db2 plan contain?

0 Answers  

---

What is difference between isnull and coalesce?

0 Answers  

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

What is db2?

0 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What is buffer pool in the db2 database?

0 Answers  

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---