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
;

Mention the various locks that are available in db2.

0 Answers  

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

what's the error code for Unique Index Violation?

2 Answers  

---

How do I import a csv file into db2?

0 Answers  

---

What is concurrency in db2?

1 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

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

1 Answers   IBM,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

how can we find nth max salary from A table

5 Answers   IBM,

---

is there any restrictions for unions ?

4 Answers   Patni,

---