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 it possible using max on a char column?

1122

Mention the definition of cobol in varchar field.

1226

What is ibm db2 connect?

974

What is package in cobol db2?

1105

Explain various types of locks in db2?

1125

Define buffer pool.

1032

Mention the different locking levels that are available in db2.

1116

What is rct?

1209

What language is db2 written in?

1026

What is the maximum size of varchar data type in db2?

1115

What is coalesce in db2?

1105

What is db2? Explain.

1015

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1137

List out the three types of page locks that can be held.

1135

How to execute stored procedures?

1109