SELECT Columns FROM Table GROUP BY Columns HAVING COUNT(*)

What is the SQL query to select, delete and get count of
duplicate rows in DB2?

Question Posted / hkhatri27

2 Answers
9257 Views
I also Faced
E-Mail Answers

Answer Posted / hkhatri27

SELECT Columns
FROM Table
GROUP BY Columns
HAVING COUNT(*) > 1;

~ Himanshu

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is null in db2?

1011

What is check constraint in db2?

1071

What is the use of with ur in db2?

1047

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2713

What is clone table?

1034

What is buffer pool and list some of them?

1015

What is reorg?

1146

How do I change the column size in db2?

1149

Can we delete records from view?

962

How and when does the db2 enforces the unique key?

1079

What is a db2 cursor?

1043

What are host variables in db2?

1044

What is rct?

1225

Explain about open switch business continuity software?

1122

When the like statement is used?

1220