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
;

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

1 Answers  

---

What does db2 blu stand for?

0 Answers  

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

What is a Database Request Module(DBRM)?

4 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

What is a DB2 access path?

1 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

Which component is used to execute the sql statements?

0 Answers  

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

What is a clustering index?

2 Answers  

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

How to rename a table in DB2 ?

0 Answers   MCN Solutions,

---