Answer Posted / anshuman

Select column_name1,column_name2
from table_T
group by column_name1 having count(*)>1

it will give all the duplicates value of column_name1

Define predicate?

639

---

What is db2 connect?

596

---

Why select is not preferred in embedded sql programs?

705

---

What does db2 stand for?

596

---

List some fields from sqlca?

607

---

---

What is bind package and plan in db2?

591

---

What is db2 command?

578

---

How to resolve deadlock issue

17941

---

What are the various isolation levels possible?

643

---

What is phantom read in db2?

636

---

What are the two types of logging in the db2 database? Explain them.

568

---

What is db2? Explain.

599

---

What's The Percentage Free Space ?

762

---

What is isolation level in db2?

575

---

What is a bind card?

679

---