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 the role of union all and union

0 Answers  

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What is iseries database?

0 Answers  

---

What is db2 look?

0 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

What is a db2 package?

0 Answers  

---

What is the physical storage length of time data type?

0 Answers  

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---