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

What is the physical storage length of the data types date, time, and timestamp?

1092

---

What is host variable in db2 cobol?

1081

---

What is meant by dclgen?

1113

---

What is the clustering index in the db2 database?

1003

---

Which are the db2 tools to protect integrity of the database?

1124

---

What is data manager?

1056

---

What is scrollable cursor in db2?

1059

---

What is drop table?

1016

---

What is dbrm? When it will be created?

1029

---

How to find primary key of a table in db2?

1066

---

What is with ur in db2?

1320

---

Define data page.

1074

---

What is cursor with hold option in db2?

1075

---

What is commit in db2?

1060

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

---