Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having Count

How to select the duplicate rows from a table?

Question Posted / nans

Answer Posted / nans

Select FIELD1 From <TABLENAME> As Temp Group By FIELD1 Having
Count(*) >1;

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you stop a db2 database in linux?

1056

What is meant by dclgen?

1173

What is sqlca?

1131

What does a deadlock mean in DB2?

1217

can all users have the privilage to use the sql statement select * (dml)?

1222

How do I delete a table in database?

1077

Are views updateable?

1234

How does cobol compile db2 program?

1128

Explain the function of data manager.

1097

What is the reason behind not using select * in embedded sql programs?

1167

what is a corelated subquerry?

1169

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1151

Mention the definition of cobol in varchar field.

1315

How do I delete a table in db2?

1124

How do I copy a table in db2?

1055