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
9278 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

Which component is responsible for processing sql statements and selecting access paths?

1127

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

What kind of database is db2?

1036

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535

How to run db2 command in windows?

1193

Explain about rct in db2?

1109

What is declare cursor?

1122

What is the difference between cursor and select statement?

1101

Which are the db2 tools to protect integrity of the database?

1120

What are the various data types available in db2?

1094

What is syscat in db2?

1010

What is the maximum No of rows per page?

1067

What is commit in db2?

1055

What are catalog tables in db2?

1048

What is the difference between bind and rebind in db2?

1449