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

What is bind in db2?

1089

What is a Foreign Key?

1137

Can we insert update delete in view?

1021

What is difference between rollback and commit?

1201

What are the benefits of using the db2 database?

1287

What do you mean by between and in? Is between inclusive of specified range values?

1139

How do I copy a table in db2?

1052

Explain correlated sub-queries.

1091

What are host variables in db2?

1120

What do you mean by rollback?

1027

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

What is the use of reorg in db2?

1137

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1107

What is isolation level in db2?

1065

What is dbrm? What it contains? When it will be created?

1099