select field name from tablename where group by field name having count(f

How to select the duplicate rows from a table?

Question Posted / channabasappa

Answer Posted / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is plan in cobol db2?

1073

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

1116

What is reorg?

1086

What db2 400?

1118

what is the responsibility of the construction superintendent

2092

How to execute stored procedure in db2 command editor?

998

What is the physical storage length of time data type?

1077

What does runstats do in db2?

1036

Explain about dbrm.

997

What is the difference between bind and rebind in db2?

1404

How will you return the number of records in table?

886

How to resolve deadlock issue

19907

What is the difference between db2 and oracle?

1072

How do you select a row using indexes in db2?

1081

What are packages in db2?

982