select distinct from <field name> from <table name>

How to select the duplicate rows from a table?

Question Posted / pandu

Answer Posted / pandu

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do you find the maximum value in a column in db2?

1106

How many databases can be created inside an instance in db2 ?

1035

What is phantom read in db2?

1160

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2180

What are types of indexes?

1073

What are the full forms of spufi and dclgen and why are they used?

1087

What is db2 plan table?

1049

How do I connect my db2 database to ibm?

1051

What are host variables in db2?

1072

what are bind concepts in db2 cobol?

1092

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

1127

Can there be more than one cursor open for any program?

1169

How can you count the number of rows from a table tab?

1091

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

1122