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 and rebind in db2?

1141

What is a cursor in programming?

1076

What is meant by dclgen?

1115

What's The Percentage Free Space ?

1228

How can you classify the locks in db2?

1093

What are packages in db2?

1026

What is collection in db2 bind?

1021

Explain correlated sub-queries.

1038

What is dclgen (declaration generator)?

1066

How to restart a DB2 program?

1911

What is dbrm library?

1073

What are host variables in db2?

1075

What is db2? Explain.

1052

How can the duplicate values be eliminated from db2 select?

1106

What is a buffer in memory?

1065