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

Answer Posted / hkhatri27

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

~ Himanshu

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is db2 a database?

1028

How do I optimize a query in db2?

1150

How to find the number of rows in a db2 table?

1155

How do I import data from excel to db2?

1128

Are views updateable?

1235

How do I connect my db2 database to ibm?

1087

i want to maintain uniqueness on pdf without make lf??????????

2204

How to test SQL -911 error while developing COB-DB2 program

7671

What do you mean by cursor?

1032

If I have a view which is a join of two or more tables, can this view be updateable?

1185

What is check constraint in db2?

1164

What is explain plan in db2?

1050

What is db2 purescale?

1053

Differentiate between cs and rr isolation levels? Where do you specify them?

1120

Can you tell me how can you find out the # of rows updated after an update statement?

1147