Answer / 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

Answer / mahesh babu

select column_name,count(*) from table_name group by
column_name having count>1.

Answer / naresh k

select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name

Answer / pandu

To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.

What is REORG? When is it used?

4 Answers  

---

What is bind and rebind in db2?

0 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

What is alias in db2?

0 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

Is db2 a mainframe database?

0 Answers  

---

Is db2 free?

0 Answers  

---

How to compare data between two tables in db2?

0 Answers  

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---