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

Explain correlated sub-queries.

589

---

What is access path in db2?

566

---

What does db2 mean?

589

---

How can we read records for specific member in CL? AND rpg?

235

---

What does db2 stand for?

600

---

---

Why do we bind in db2?

634

---

What is the advantage in De-normalizing tables in DB2?

750

---

How do you select a row using indexes in db2?

647

---

How many databases can be created inside an instance in db2 ?

605

---

What is the picture clause of null indicator variable?

694

---

Mention the definition of cobol in varchar field.

700

---

What are foreign keys in db2?

617

---

What is bind plan?

616

---

Explain about open switch business continuity software?

567

---

How do you stop a db2 database in linux?

570

---